I need to make it so that the formula in AI7 maxes out when AG7 hits 820000 and when its equal to or goes over 820001 it stays at that max. The only thing that is making it hard on me is that the max dosnt just depend on the total in AG7 it also depends on the multiplier in F39.
Here is what i have so far...
=IF(AG7<820000,(AG7-420000)*F39,(AG7-420000)*IF(OR( AG7<420000,AG7<820000),(AG7-420000)*F39,F39))
and the spreadsheet is attached. im working in the Feb tab
Bookmarks