Help writing formula

  • Thread starter Thread starter HannahC
  • Start date Start date
H

HannahC

I need to write the folloiwng formula, but I can't make if
work.
if A1 >= 50 but < 51 then value should be 10 AND if a1 >=
51 but < 52 then the value should be 20
 
Try:

=IF(AND(A1>=50,A1<51),10,IF(AND(A1>=51,A1<52),20,""))

The above assumes that blanks [""] are to be returned as the value_if_false
 
Back
Top