Question
Write one Microsoft excel formula that works for conditions below on cell C1 for any number:
a) IF A1+B1<=4, return $20
b) IF A1+B1>4 but <=9, return $35
c) IF A1+b1>9 but <=14, return $50
d) And IF A1+B1>15, return $75
a) IF A1+B1<=4, return $20
b) IF A1+B1>4 but <=9, return $35
c) IF A1+b1>9 but <=14, return $50
d) And IF A1+B1>15, return $75