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

Maybe

=IF(ISERROR(YourFormula),"",YourFormula)

Mike

"RobertSE6" wrote:

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)

In article ,
RobertSE6 wrote:

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

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)


"RobertSE6" wrote in message
...
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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RobertSE6" wrote:
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

Thank you all very much

Rob

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RobertSE6" wrote:
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