IF statement problem

[pearl11]

I am trying to create a excel formula where
if D1 is Y then A1=0
if DI is N then take info from F1

so the total equation not including the if statement above would be:
A1+B1+C1+N=

 

[VoG]

Try in A1

=IF(D1="Y",0,IF(D1="N",F1,""))

 

[pearl11]

Just tried it and I am getting a parse error.

 

[VoG]

If you are using as non-English version of Excel


=IF(D1="Y";0,IF(D1="N";F1;""))

 

[Scott Huish]

Possibly:

=IF(D1="N";F1;0)

 

[pearl11]

vog, i went back and did the formula you suggested in a simple document and it works exactly as I asked.

i must be doing something wrong in my much bigger spreadsheet and will try to figure out what I am not doing right.

thanks for the answer and fast reply

hotpepper thanks for your input. if for some reason I can't get vog's formula to work in my overly complicated spreadsheet I'll try your formula