Jan 19 2020 07:22 AM
I have this formula (1596-15%*(G34-36783)) but the result has to be in between 0 and 1596 how can I do this?
Jan 19 2020 10:49 AM
Perhaps this formula?
=IF(MIN(1596-15%*(G34-36783),1596)<0,0,MIN(1596-15%*(G34-36783),1596))
Jan 19 2020 01:40 PM