I am trying to make a cell equal a specific number based upon the text of
another cell,i.e., if cell A3 is Saturday, then I want G3 to equal 22. If
it's Sunday then I want G3 to be 75. I've tried using the following format
from another post, but all i get is the very last number meaning that none of
them are true:

=IF(A1<=99,A1+(A1*0.15),IF(A1<=2000,A1+(A1*0.1),IF (A1<=5000,A1+(A1*0.7),IF(A1<=15000,A1+(A1*0.5),A1+ (A1*0.4)))))

is it beacuse I'm looking for text? Do I need to use another formula?