Two formulas in one cell

[JScales]

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!

[Pete_UK]

You can do this:

=IF(A1="", Sum(C2*.85) + (C3*1.85), IF(A1="JS", Sum(C2*.87) + (C3*2.20), "")

Hope this helps.

Pete

[JScales]

Thanks! The actual formula I have is below and it doesn't seem to work. I am sure it is the way I have parenthesis:
IF(C11="", Sum(1.05+(H11*.85)+(I11*0.15)+ G11)*0.75, IF(C11="JS", Sum(2.4+(H11*1.65)+(I11*0.15)+(G11)*0.75, "")

C11 is where I put in the value JS

[Pete_UK]

Well, those SUM terms are different than the ones you originally posted, but assuming the new ones are what you require, you can write the formula like this:

IF(C11="",(1.05+H11*.85+I11*0.15+G11)*0.75,IF(C11="JS",(2.4+H11*1.65+I11*0.15+G11)*0.75,""))

I've got rid of all the spurious brackets and the SUM functions (which are not needed), and I've added another bracket to the end which I inadvertently missed off in Post #2.

There may still be some adjustments to make, as it is not exactly clear from your formula whether you intend to multiply everything by 0.75, or just the G11 term. As it stands, the 0.75 is multiplying everything, but if you only intend it to multiply the G11 term then you should omit all the brackets shown in red.

Hope this helps.

Pete