calculate % if a cell is above an amount

September 6, 2011 at 07:45:49
Specs: Windows 7
Hi could someone wright a formula for this please.

spread sheet with values. Example cell B2 has a value of £145 from a sale .i want to calculate a % rate from that value. in C2 i.e.20% from a valule of £0-80 & 25% if the value is greater than £80.

thanks


See More: calculate % if a cell is above an amount

Report •

#1
September 6, 2011 at 08:43:32

Report •

#2
September 6, 2011 at 09:52:50
WORKS A TREAT THANKS !!!!

Report •
Related Solutions


Ask Question