IF function won't post cell value
 

Trying to get this to work:

IF cell C4=0 then post cell F4 value IF cells C4 and F4
are both 0 then post cell I4's value.

=IF(C4=0,F4, IF(C4=0,F4=0,I4))

If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4
are 0 all it will post in I4 is 0 not I4's value.
--
Loren

IF function won't post cell value
 

See if this does the trick for you:

=IF(AND(C4=0,F40),F4,IF(AND(C4=0,F4=0),I4,0))
--
Kevin Backmann


"Loren" wrote:

Trying to get this to work:

IF cell C4=0 then post cell F4 value IF cells C4 and F4
are both 0 then post cell I4's value.

=IF(C4=0,F4, IF(C4=0,F4=0,I4))

If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4
are 0 all it will post in I4 is 0 not I4's value.
--
Loren

IF function won't post cell value
 

Try: =IF(C4=0,F4,IF(AND(C4=0,F4=0,I4)))

"IF C4= 0, THEN F4, ELSE IF C4 = 0 AND F4 = 0, THEN I4"

Dave
--
Brevity is the soul of wit.


"Loren" wrote:

Trying to get this to work:

IF cell C4=0 then post cell F4 value IF cells C4 and F4
are both 0 then post cell I4's value.

=IF(C4=0,F4, IF(C4=0,F4=0,I4))

If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4
are 0 all it will post in I4 is 0 not I4's value.
--
Loren