Help writing formula

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hlookup 3 criteria?? 0
SUMPRODUCT where between 2 dates 3
Complex formula to count cells 1
Baffeling IF statement 7
complex lookup 8
Drop down list control value in vba 2
I need to Write a Formula 1
IF AND Statement Needed 2

Top