IF FUNCTION

M

moknows

Joined
Aug 20, 2014
Messages
1
Reaction score
0
I need help with this formula. I am trying to get a value based on a range of numbers

=IF(B17>1,"75",IF(B17>11,"100",IF(B17>22,"150",IF(B17>27,"200"))))
 

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

Lookup for the first occurrence 4
Counting by color 3
Conditional =CONCATENATE formula 2
VLOOKUP and IF formula 1
Using Validation Ref # within LOOKUP 3
Function Help Please .... 3
Reference the same cell based on tab name 1
IF Function Help 3

Top