Oct 19 2021 09:48 AM
I am trying to create a formula so that when a certain number appears in the cells in Column F that the logic applies the correct PayPal fee in Column G. The fee is not set percentage, so I can't make it a math formula. The fee percentage changes the higher the value. I used the "IF" formula to say that when the cell in Column F is $45 then put $1.39 in the cell in Column G. BUT - F could also be $90, $135 or $180. I want the formula to say that if F is $45 then G is $1.39; if F is $90 then G is $2.28; if F is $135 then G would be $3.18 and if F is $180 then G would be $4.07. I don't know how to give the formula 4 different options of which fee to put into Column G. Thanks for the assistance!
Oct 19 2021 10:18 AM
Oct 19 2021 11:18 AM
@Deleted Yes - except it's telling me that it can only have a maximum of 3 equations, and I need 4.
Oct 19 2021 11:29 AM
SolutionOct 19 2021 11:32 AM
Oct 19 2021 11:35 AM
Oct 19 2021 11:39 AM
Oct 19 2021 11:29 AM
Solution