LinkBack URL
About LinkBacks
Hello Dear Friends,
Please refer the attached worksheet and I am pulling my hair out thinking of a formula which when matches the given % should give out the required conditions.
Any help will be greatly appreciated
Excel 2010
Hello Dear Friends,
Please refer the attached worksheet and I am pulling my hair out thinking of a formula which when matches the given % should give out the required conditions.
Any help will be greatly appreciated
Excel 2010
May be this........
and then drag to M12.
B12 =IF(B$10*100>200,(((200%*B6)-B6)*10)+((B6-(0.9*B6))*5),IF(B$10*100>100,((B7-B6)*10)+((B6-(0.9*B6))*5),IF(B$10*100>=90,(B7-(B6*0.9))*5,0)))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
hi joseph. 1 other way:
=IF(B10>2,(2*B6-B6)*10+0.1*B6*5,IF(B10>1,(B7-B6)*10+0.1*B6*5,IF(B10>=0.9,(B7-0.9*B6)*5,0)))
B12 is supposed to be 0? 900 - 90% * 1000 = 0
and for this part:
row 6 value - 90% of row 6 value is simply 10% of row 6 valuePLUS ((Row 6 value for the month)-(90% of Row 6 value for the month))* $5
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks benishriyo and sktneer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks