Nested IF function (simple)
 

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!

Nested IF function (simple)
 

Hi,

Am Fri, 29 Jun 2018 07:01:15 +0100 schrieb TeKouma:

Can anyone tell me why I am getting errors?
https://i.imgur.com/vRhe5Vz.png

try:
=E2+IF(L2=12.72,35,IF(L2=17.74,50,0))


Regards
Claus B.
--
Windows10
Office 2016

You cannot put e2+if.

Nested IF function (simple)
 

Hi,

Am Fri, 29 Jun 2018 17:33:29 +0100 schrieb TeKouma:

You cannot put e2+if.

you didn't test it!


Regards
Claus B.
--
Windows10
Office 2016

Cannot put "=e2+if("....

I have.... =IF(L2=12.72,E2+35,IF(L2=17.47,E2+50)

Anyone?

Yah, you can't do that. Here's what it looks like with that https://i.imgur.com/oSD6WfS.png Your suggestion seems logical as well though.

Nested IF function (simple)
 

Hi,

Am Fri, 29 Jun 2018 19:05:25 +0100 schrieb TeKouma:

Yah, you can't do that. Here's what it looks like with that
https://i.imgur.com/oSD6WfS.png Your suggestion seems logical as well
though.

my formula is tested and it is working. If it doesn't work in your
workbook, your values are text. It seems that they have leading oder
trailing spaces.
If you can't get it to work, send your workbook to
claus_busch(at)t-online.de


Regards
Claus B.
--
Windows10
Office 2016

Nested IF function (simple)
 

The error may caused by cell format.
If I can see the workbook file, I may find out what's wrong actually.

"TeKouma" дÈëÏûÏ¢
...

Cannot put "=e2+if("....

I have.... =IF(L2=12.72,E2+35,IF(L2=17.47,E2+50)

Anyone?




--
TeKouma

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.