Hi, I am using a formula to produce a percentage increase
=IF(G63>$C$80,C63*5%,0)
Is there a way of limiting the increase to a maximum of 1?
thanks
Hi, I am using a formula to produce a percentage increase
=IF(G63>$C$80,C63*5%,0)
Is there a way of limiting the increase to a maximum of 1?
thanks
Last edited by Marvo; 05-19-2018 at 07:09 AM.
TryFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
That works a treat. Thank you.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks