Hi, im looking to cap a percentage (in this case at 5%) is that possible with an If Formula?
If % in A is higher than 5% (B) then C should answer the difference.
I have the below formula to do that,
=If(A1=>B1,A1-D1,0)
However I need to have the Answer capped at 5%, Can anybody help at a way of capping the answer in C at 5%
A B C
20% 5% Answer
Thanks
Bookmarks