![]() |
#8
|
||||
|
||||
![]() Quote:
Anyway you have 7 nested IF's which is the maximum allowed , so, no problem there Also, there is an error in your formula =IF($D137<=50,($D137*G$1),IF(AND($D137>50,$D137<=1 50),($D137*H$1),IF(AND($D137>=151,$D137<=700),($D1 37*I$1),IF(AND($D137>=701,$D137<=10000),($D137*J$1),IF(AND($D137>=1001,$D137<=2000),($D1 37*K$1),IF(AND($D137>=2001,$D137<=3000)*($D137*L$1 ),IF(AND($D137>=3001),$D137*M$1))))))) I think the value in red should be 1000 not 10000 ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
manich1 | Excel | 2 | 12-07-2011 02:59 PM |
![]() |
UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
![]() |
Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
![]() |
YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
![]() |
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |