English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Help I dont know how to do this. The X (column A) is a random number.

Calculate y, (column B) based on the x value listed in column A. If 0 ≤ x ≤ 3, then y = 2x. If 3 < x ≤ 10, then y = (x-3)2 + 6. If x < 0, note "negative x". If x >10, note "x is too large".

2007-12-18 10:38:51 · 1 answers · asked by Dave K 1 in Computers & Internet Software

1 answers

had ot break it up into 3 lines, but it should be 1 formula

=IF(A2<0,"negative x",(IF(A2<4,+
A2*2,IF(+A2<11,
+(+A2-3)*2+6,"x is too large"))))

2007-12-18 11:33:58 · answer #1 · answered by expletive_xom 7 · 0 0

fedest.com, questions and answers