Feb 01 2022 11:57 PM
Hello
I'm trying to work out a varied percentage of a cell value to display as currency.
For example if B1 is between £0 and £2000 then I need C1 to display 7% of B1. If B1 is between £2001 and £3500 I need C1 to display 8% of B1, if B1 is £5000 or over I need C1 to display 10% of B1 etc.
Any help would be greatly appreciated.
Kind regards
Leon
Feb 02 2022 12:16 AM
@leon_the_car_guy Try this in C1 and format the cell as a percentage.
=LOOKUP(B1,{0,2001,3501},{0.07,0.08,0.1})
Feb 02 2022 12:39 AM
Feb 02 2022 12:56 AM
I guess that will be =B1*LOOKUP(...)
Feb 02 2022 01:02 AM