D
Del
Hi
I am trying to total (in cell F4) the percentage of a range of cells but
with a minimum value.
In cells F14:F63 I have the amounts:
F14 600
F15 500
F16 350
F17 700
F18 275
..
..
etc
I want to total 10% of each of the figures, but where the result is less
than 50, it should be rounded up to 50. So...
F14 600 = 60
F15 500 = 50
F16 350 = 50
F17 700 = 70
F18 275 = 50.
Have tried various methods but can't find a way to make it work. All help
greatly appreciated.
Regards
I am trying to total (in cell F4) the percentage of a range of cells but
with a minimum value.
In cells F14:F63 I have the amounts:
F14 600
F15 500
F16 350
F17 700
F18 275
..
..
etc
I want to total 10% of each of the figures, but where the result is less
than 50, it should be rounded up to 50. So...
F14 600 = 60
F15 500 = 50
F16 350 = 50
F17 700 = 70
F18 275 = 50.
Have tried various methods but can't find a way to make it work. All help
greatly appreciated.
Regards