Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nested If statement
I need to write a nested 'if' stating something like this:
=IF((F5<1799),"87",IF(F5 between 1800and2499),116,170) I am unsure of the between tis number and that number bit. All help appreciated tia -- Jock Waddington |
#2
|
|||
|
|||
=IF(F5<1799,87,IF(AND(F5=1800,F5<=2499),116,170))
HTH Jason Atlanta, GA -----Original Message----- I need to write a nested 'if' stating something like this: =IF((F5<1799),"87",IF(F5 between 1800and2499),116,170) I am unsure of the between tis number and that number bit. All help appreciated tia -- Jock Waddington . |
#3
|
|||
|
|||
Thanks Jason, job done
Jock "Jason Morin" wrote: =IF(F5<1799,87,IF(AND(F5=1800,F5<=2499),116,170)) HTH Jason Atlanta, GA -----Original Message----- I need to write a nested 'if' stating something like this: =IF((F5<1799),"87",IF(F5 between 1800and2499),116,170) I am unsure of the between tis number and that number bit. All help appreciated tia -- Jock Waddington . |
#4
|
|||
|
|||
"Jason Morin" wrote in message
... =IF(F5<1799,87,IF(AND(F5=1800,F5<=2499),116,170)) Contains the error, (if it is an error), in the OP's data where by 1799 is treated as being greater than 2499 I am sure that you meant: =IF(F5<=1799,87,IF(AND(F5=1800,F5<=2499),116,170) ) or =IF(F5<1800,87,IF(AND(F5=1800,F5<2500),116,170)) "Jock W" wrote in message ... Thanks Jason, job done so, being as the OP did not ask for a blank cell if no data in F5, just for fun: =87+(F51799)*29+(F52499)*54 Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Jason Morin" wrote in message ... =IF(F5<1799,87,IF(AND(F5=1800,F5<=2499),116,170)) HTH Jason Atlanta, GA -----Original Message----- I need to write a nested 'if' stating something like this: =IF((F5<1799),"87",IF(F5 between 1800and2499),116,170) I am unsure of the between tis number and that number bit. All help appreciated tia -- Jock Waddington . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) |