Try something like:
=IF(OR(A1="",B1=""),"",<expression)
where A1, B1 are the 2 precedents
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Min" wrote:
I have a formula in one cell that returns a value dependant on data entered
into 2 other cells. If no data is entered into either one of these cells then
I get a return of #value! How can I stop this from displaying?