IF Statement

[FredW]

I am attempting to write an IF statement in cell P1 that
looks at cell N1 to see if there is a value there. If the
cell N1 contains a null value, then it should use the
value that is in D1 and place it into P1. If cell N1
contains any value, then that value should be placed in
P1.

Thanks for any help!

Fred

 

[Peo Sjoblom]

=IF(N1="",D1,N1)

 

[Harald Staff]

Hi Fred

=IF(N1="",D1,N1)
assuming that the number zero is a "value" in this context.

 

[Andy B]

Fred

In P1 try:

=IF(N1="",D1,N1)

Andy.

(There are 10 types of people in the world.
Those that understand binary, and those that don't.)