Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 28-04-2012
Member
 
Join Date: Mar 2012
Posts: 41
A small confusion with the formula calculation in Excel 2007

I have developed a small formula in Excel 2007, I am trying to add another and the % increaser works perfect. But in case of decreasing it should be increasing the cost but is rather decreasing it.

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 come up with a reliable solution. Desperately awaiting one since I am working on deadlines.
Reply With Quote
  #2  
Old 28-04-2012
Member
 
Join Date: Jul 2011
Posts: 618
Re: A small confusion with the formula calculation in Excel 2007

I would recommend the use of the following chnges in the formula, please checkup and try out if this works your purpose:

=$D862*lookup($d862,{0,50,150,700,1000,2000,3000}, {J$2$2})

please make sure you post back it works because this might benefit other users too as I myself have not used it, giving you a fresh suggestion, to try.
Reply With Quote
  #3  
Old 28-04-2012
Member
 
Join Date: Mar 2012
Posts: 41
Re: A small confusion with the formula calculation in Excel 2007

Hi and thanks a lot for the suggestion it actually worked. I would recommend the use of lookup function to everyone. However, I am not very well versed with the lookup function but considering the fact that it is so useful and crucial at situations, I would love to learn more about it.

thanks again, I am obliged!
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "A small confusion with the formula calculation in Excel 2007"
Thread Thread Starter Forum Replies Last Post
How to accept label under formula option in Microsoft Excel 2007 Mathrubootham MS Office Support 2 16-02-2012 08:02 PM
Formula for Fixed & Reducing Balance Loan Calculation Bala!aditya MS Office Support 2 11-01-2012 04:03 PM
Copy paste formula automatically in Excel 2007 Macadrian Software Development 3 12-11-2009 08:19 PM
Formula Problem in Excel 2007 hariharan_00 Windows Software 2 07-01-2009 09:33 PM
Formula help in excel 2007 Muhammad Waqar Windows Software 1 24-11-2008 07:29 PM


All times are GMT +5.5. The time now is 09:33 PM.