I need help to understand how to enter a formula to give a maximum result of 100%
For example if sales target = 100,000 and sales achievement entered= 125'000 then I need the percent of sale achieved to show 100% not 125%
If the sale achieved entered= 75,000 then I need the same cell to show 75% achieved....
I'm sure their must be an easy way of doing this but I keep getting errors in the formula so any help would be appreciate.
Bookmarks