#1
|
|||
|
|||
Formula calculation
I have a formula(below) that does a markup for charges. I am using senario manager to add different %increases which works fine., But when I try to decrease a % by using a negative number (-25%) the % is changed correctly but the math part increses the cost rather than decreasing the cost. IF($D862<=50,($D862*J$2),IF(AND($D862>50,$D862<=15 0),($D862*K$2),IF(AND($D862>=151,$D862<=700),($D86 2*L$2),IF(AND($D862>=701,$D862<=10000),($D862*M$2) ,IF(AND($D862>=1001,$D862<=2000),($D862*N$2),IF(AN D($D862>=2001,$D862<=3000)*($D862*O$2),IF(AND($D86 2>=3001),$D862*P$2))))))) Can anyone tell me why this is happening? and How to fix this? Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculation within Cells | manich1 | Excel | 2 | 12-07-2011 02:59 PM |
Excel Calculation Problem | UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
Help with 'hours worked' calculation... | Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
Excel 2010 formula rounds - arithmetic average calculation | YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
Mail Merge Calculation Error | Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |