IF Statement

  • Thread starter Thread starter FredW
  • Start date Start date
F

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
 
Hi Fred

=IF(N1="",D1,N1)
assuming that the number zero is a "value" in this context.
 
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.)
 
Back
Top