Forum Discussion
Excell formula for adding different percentage to different values
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 ...
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.