LinkBack URL
About LinkBacks
hi
i have to calculate 5% increase on 98.5% but one condition it should not beyond 100%,how to do this please help me
hi
i have to calculate 5% increase on 98.5% but one condition it should not beyond 100%,how to do this please help me
I would need to see a sample of what you got, with a sample of what you expect, the question is just a little too vague for me to guess at
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
hi
Please refer the attachement
Are you looking for this?
=IF(C6+C6*5%>100%,100%,C6+C6*5%)
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.
no sktneer,i want to calculate 5% increase on each but it should be below 100% only,for example i have 98%,5% increase means it should be 99% or something not above 100%
see the attachment
If you don't want to populate it when it is greater than 100, you can use the below formula...It will only calculate if the percentage increase is less than 100, otherwise leave the cell blank.
=IF(C6+C6*5%>100%,"",C6+C6*5%)
If this is not what you require, please upload sample sheet with the desired output.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks