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

=IF(B2<=80, B2*0.2, B2*0.25)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

WORKS A TREAT THANKS !!!!

Ask Your Question

Weekly Poll