#N/A

[Bunny]

Would appreciate some help on this............

I have some formulas set up in a spreadsheet that other people will fill
progressively. In cells where the formula has no feeder' data to provide a
result it displays "#N/A".

Is there something I can add to the formula to make the cell appear blank
unless there is data to go in there?

 

[Norman Harker]

Hi Bunny!

Use:

=IF(ISNA(YourFormula),"",Yourformula)

 

[Bunny]

Thank you again Mr Harker

 

[Norman Harker]

Hi Bunny!

Pleased to help. Last person to call me "Mr." had me transported to
Australia!

The solution given was a general solution and not necessarily the best
for your particular formula.