Quote:
Originally Posted by TeKouma
Can anyone tell me why I am getting errors? https://i.imgur.com/vRhe5Vz.png
Tried another forum and nobody could figure it out, although I think it's fairly simple. I'm sort of new to Excel and I think the syntax in the formula bar is slightly off.
If the shipping is $17.47 in column L, I simply want it to "ADD" $50 to column G. (Look at the formula). I figured out how to add $35, but adding another "IF" for 50 isn't working.
THANKS!
|
First you missed thew close Paren at end )
this works fine
=IF(L2=12.72,E2+35,IF(L2=17.47,E2+50))
I agee you must have a Text in there somewhere.