How to stop cell showing #VALUE! please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the form I'm working on the user puts in a couple of values to get an
answer - is there a way to stop #VALUE! being displayed in the result cell
before they put in the values in the other cells - if you see what I mean

Thanks

Rob
 
One way:

If your formula depends on, say, an entry in cell A1, then instead use

=IF(A1="","",<your formula>)
 
If you are using Excel 2007, you can use the IFERROR function.

=IFERROR(your_formula,value_to_use_if_error)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
For multiple inputs, you could also use something like this:

In D2: =IF(COUNTA(A2:C2)<3,"",<yourformula>)
where your formula is dependent on inputs in A2:C2
 
Thank you all very much

Rob

Max said:
For multiple inputs, you could also use something like this:

In D2: =IF(COUNTA(A2:C2)<3,"",<yourformula>)
where your formula is dependent on inputs in A2:C2
Click to expand...
 
Back
Top