Thread: [Solved] Formula calculation
View Single Post
 
Old 02-23-2012, 12:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
Quote:
If you go to senario and choose new, then show,
I'm sorry I don't understand what you mean

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 ?
__________________
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
Reply With Quote