I am trying to have an if then function linking a cell to a cell on another sheet. I need the cell to be blank if the linked cell is blank, I need it to display a number if it has a number and I need it to display text if it contains text.
I have tried: =IF('Sheet1'!A10="","",IF(ISTEXT('Sheet1'!A10),'181A'!A10,""),IF(ISNUMBER('Sheet1'!A10),'Sheet1'!A10,""))
It seems to do text or number but not both. It gives me the error "you have entered too many arguments for this function.
It works fine for text:
=IF('Sheet1'!A10="","",IF(ISTEXT('Sheet1'!A10),'Sheet1'!A10,""))
and for Numbers:
=IF('Sheet1'!A10="","",IF(ISNUMBER('Sheet1'!A10),'Sheet1'!A10,""))
Any Ideas?
Thanks!
Saybier
Bookmarks