IF statement

Y

Yinka

Hi All,

I need help, I am trying to get a IF statement to return either a date or
text, but I keep getting a zero(0) if the statement is true

=IF('Input sheet'!A1=" "," ",'Input sheet'!A12)

the reuslt I get is zero

Thanks
 
C

CLR

Your formula appears to work fine in my Excel 97 Test Sheet. It follows the
logic of: IF A1 contains as single space, then return a single space,
otherwise, return the value displayed in A12..........

You may really meant to do this........

=IF('Input sheet'!A1="","",'Input sheet'!A12) ......which means, IF A1 is
empty, then leave this cell empty, otherwise return the value in A12.

hth
Vaya con Dios,
Chuck, CABGx3
 
Y

Yinka

Many thanks. You are right, your suggestion was what I really meant.

Thank you

Regards,
Yinka
 
Top