Wed 9 Jan 2008, 14:04Delegate Simon said...
Simon has attended:
Excel Intermediate course
Displaying Formulae
when i put a formula into a cell that depends on other data being entered into the spreadsheet is there any way that the cell can be displayed as a "blank" untill the other info has been entered? Hope this makes sense!!
Wed 9 Jan 2008, 14:55Delegate Paul said...
RE: Displaying Formulae
hi Simon.
this can be done, by using the ISBLANK function. if you have a formula such as =if(A1>=10,"yes","no") The cell in which your formula is in, will always return "no" when there is nothing in cell A1
what you can do is tell the computer to display nothing if the cell is blank:
=IF(ISBLANK(A1),"",IF(A1>=10,"yes","no"))
Hope you can work this round your own formulae
Paul
