I have a simple addition =SUM(E5:F5) with total in E6
If I wanted to CAP the total to say 150, as the maximum allowed, is there an easy way to do that?
I'm saying even if the total was 156 or even 212 then the cell would read 150?
Thanks for your help
Bookmarks