Excel IF Function

[Maceleven]

Real beginners stuff
How do I write an if function for A1=0 and B1=0 and C1=0 giving a simple "y" or "n"

Thanks

 

[klmorgan]

=IF(AND(C4=0, D4=0,E4=0), "Y", "N")

Regards

Keith

 

[ETID]

Just a variation...

=if(sum(c4:e4)=0,"Y","N")

 

[TonyJollans]

Hi ETID,

C4 = -2
D4 = +1
E4 = +1

..............

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[ETID]

...Good point Tony,

...Maceleven, ...I'd go with klmorgan's response if what given what TonyJollans has pointed out is applicable.