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

=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
.

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
.

"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
.