1.

Solve : Excel 2000 formulas?

Answer»

if the sum of a cell =
1-19 then multiply by .50
20-24 then multiply by 1.00
25 & up then multiply by 2.00
Can someone please help me create this FORMULA so I don't have to manually change it every time I need an update?[glb][/glb]=IF(A1+B1&LT;20,(A1+B1)*0.5,IF(A1+B1<25,(A1+B1)*1,(A1+B1)*2))


Discussion

No Comment Found

Related InterviewSolutions