Hi, I'm having trouble with one part of a nested IF statement and I'm somewhat of a novice so that probably explains things, but after 6 hours I'm looking for help. What I currently have is:
=IF(AND(C25>0,C25>10000),5000*0.7,IF(AND(C25>0,C25<10000),(C25-5000)*.7>0,IF(C25-5000)*.7<0,0,((C25-5000)*.7)))
Where I seem to have the breakdown is the second nested IF statement where if C25>0 and C25<10000, then I want to calculate C25-5000*.7. However is this answer is negative, then I want the answer to be zero. If the answer to the calculation is positive, then I want the answer to be the number output by the calculation. Make sense? Can somehelp clean this up to make it work? Thanks in advance!
Kevin
Last edited by kcasement; 04-01-2010 at 03:00 PM.
Maybe?
=IF(C25>0,IF(C25>10000,5000*0.7,MAX(0,(C25-5000)*0.7)),0)
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Yes, that did work....and a lot simpler than what I was trying to do!Originally Posted by NBVC
Thanks a lot.
Kevin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks