It is not clear what you are trying to accomplish ... if you are trying to say that if there is a number in cell B2, then put the entry "NUM" in cell B3 otherwise leave cell B3 blank, then put in cell B3On 2002-04-16 19:43, RET79 wrote:
hi
in cell B2 i have this written
YV>100
in B3 I want to write
=IF(B2,NUM,"")
which should be equal to
=IF(YV>100,NUM,"")
but it's not.
Gosh, I have a feeling someone is going to show me up on this one, any help appreciated thanks.
RET79
On 2002-04-16 19:43, RET79 wrote:
hi
in cell B2 i have this written
YV>100
in B3 I want to write
=IF(B2,NUM,"")
which should be equal to
=IF(YV>100,NUM,"")
but it's not.
Gosh, I have a feeling someone is going to show me up on this one, any help appreciated thanks.
RET79
On 2002-04-16 19:43, RET79 wrote:
hi
in cell B2 i have this written
YV>100
in B3 I want to write
=IF(B2,NUM,"")
which should be equal to
=IF(YV>100,NUM,"")
but it's not.
Gosh, I have a feeling someone is going to show me up on this one, any help appreciated thanks.
RET79