Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jock W
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

=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   Report Post  
Jock W
 
Posts: n/a
Default

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   Report Post  
Sandy Mann
 
Posts: n/a
Default

"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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
€śUse of more then 7 nested if statement€ť Faisal Yameen Excel Worksheet Functions 3 January 12th 05 07:02 PM
€śUse of more then 7 nested if statement€ť Faisal Yameen Excel Worksheet Functions 0 January 12th 05 06:17 PM
€śUse of more then 7 nested if statement€ť Faisal Yameen Excel Worksheet Functions 2 January 12th 05 05:20 PM
7+ nested if statement? Turi Excel Worksheet Functions 3 December 20th 04 08:55 PM
Combining SUM Function with Nested If Statement Somecallmejosh Excel Discussion (Misc queries) 3 December 6th 04 05:25 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"