Excell formula for adding different percentage to different values

Occasional Visitor

I would like to know how I can make a formula to add two different percentages (65% and 85%) to different values(number) I would like to do the following:

to the number higher than 5 but lower than 19,9 , I want to add 85%

and to a number higher than 20 but lower than 99,9 i want to add 65%

 

how can I make it a formula so I can just chage a large amount of numbers to my desired value.

 

thanks to everyone with helpfull advice.

1 Reply

@Anaskraba Let's ay the number is in A1, then enter the following in B1:

=IF(AND(A1>5,A1<20),A1*(1+85%),IF(AND(A1>=20,A1<99.9),A1*(1+65%),"Invalid"))

or if your system is set to work with a decimal comma and semi-colon as the list separator:

=IF(AND(A1>5;A1<20);A1*(1+85%);IF(AND(A1>=20;A1<99,9);A1*(1+65%);"Invalid"))

 

Not that I used <20 and >=20 to end and begin the two intervals. Otherwise, any number from 19.9 up to and including 20 would not be covered. "Invalid" will be returned if the number in A is 5 or less or 99.9 or more.