Suppose a1=50, now in b1, i want Yes if a1 is grearter than 50 and simultaneously less than 150, otherwise no.
I tried this
=if(50
Please tell me the correct formula or any trick for defining ranges for such situation and i also want to know why doesnt above formula work
Plz HELP
2007-05-31 08:08:56 · 4 answers · asked by ankit m 1 in Computers & Internet ➔ Software
You need to use Conditional Formatting
=IF(A1<50, "No", IF(A1<150, "Yes", "No"))
See here for more information: http://www.homeandlearn.co.uk/ME/mes7p2.html
2007-05-31 08:18:39 · answer #1 · answered by Mat 3 · 0⤊ 0⤋
You dont need to write the numbers that the cell contains. Just the number. I mean, A1 or B6, etc
2007-05-31 15:12:30 · answer #2 · answered by Carlloss 2 · 0⤊ 0⤋
Try this
=IF(AND(A1 > 50,A1 < 150),"Yes","No")
2007-05-31 15:19:27 · answer #3 · answered by Maquis 7 · 2⤊ 0⤋
try this:
=IF(AND(A1>50,A1<150),"yes","no")
2007-05-31 15:24:00 · answer #4 · answered by Edward C 1 · 1⤊ 0⤋