Nested IF statement, what am I doing wrong?

[reneev]

I have a formula that is currently working: =IF(H3<>"PD 1 HMS W/DIFFERENTIAL","",M3*1.1)

I need to add a second formula that does the same thing, but looks for "PD 2 HMS W/DIFFERENTIAL". I thought I knew how do do it, but keep getting an error that there are too many arguments for this function. What am I doing wrong?

=IF(H3<>"PD 1 HMS W/DIFFERENTIAL","",M3*1.1,IF(H3<>"PD 2 HMS W/DIFFERENTIAL","",M3*1.1))

Basically, I need the formula to calculate if either of those phrases are used.

 

[RossTattersall]

If the outcome in both cases is the same you can use;

=IF(AND(H3<>"PD 1 HMS W/DIFFERENTIAL",H3<>"PD 2 HMS W/DIFFERENTIAL"),"",M3*1.1)

 

[Aryatect]

Hi Reneev,

If the outcome is same then @RossTattersall 's method is the best, but if the outcomes can be different then use the below formula:

=IF(H3<>"PD 1 HMS W/DIFFERENTIAL",M3*1.1,IF(H3<>"PD 2 HMS W/DIFFERENTIAL",M3*1.1,""))

 

[reneev]

This worked! what is the significance to the "AND". I thought about that, but I'm not trying to get "if this AND this then do this" so I didn't try.

 

[reneev]

Isn't' that what my original formula?

 

[Aryatect]

Almost, there was one additional argument there which might have caused error for you earlier.

Isn't' that what my original formula?