I want a formula that will provide the answer 16.9% of a value or £34.50, whichever is the greater. Is this possible - so if the value is £150 the answer is £34.50, if the value is £300 the answer is £50.70.
I want a formula that will provide the answer 16.9% of a value or £34.50, whichever is the greater. Is this possible - so if the value is £150 the answer is £34.50, if the value is £300 the answer is £50.70.
Last edited by DarthBailey; 01-21-2013 at 10:37 AM. Reason: Problem with title
hi DarthBailey, welcome to the forum. assuming data in A1, try:
=MAX(A1*16.9%,34.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
That's perfect - worked a treat cheers, just realised I need it to say £90 if greater than £90 so 16.9% of a value but no less than £34.50 and no more than £90?? Is this much more complicated?
then add a MIN:
=MIN(90,MAX(A1*16.9%,34.5))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks