I am trying to calculate a value based on another value in a certain cell. For example. If the value in A1=JS, I would like to use the formula =Sum(C2*.87) + (C3*2.20). If the cell is blank or null, then use =Sum(C2*.85) + (C3*1.85)

Thanks for any help. It seems very simple but I am struggling!