Hi all.
I have been trying (unsuccessfully, so far) to figure out how to write
syntax to check for missing data in two cells before executing a function.
For example, I know that I can write:

€œ=IF(D90, D9-C8)€�

to check to make sure there is a valid case in cell "D9" before executing
the function, but the problem is if I have no data entered in cell "C8", it
will of course simply assume that cell contains a value of "0" and run the
function anyway. I want to write something like "If D90 AND C80, THEN
D9-C8"...

Anyone have any pointers???

Thanks in advance for your help!
- Chris

One way: =IF(AND(D90,C80),D9-C8,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote:
Hi all.
I have been trying (unsuccessfully, so far) to figure out how to write
syntax to check for missing data in two cells before executing a function.
For example, I know that I can write:

€œ=IF(D90, D9-C8)€�

to check to make sure there is a valid case in cell "D9" before executing
the function, but the problem is if I have no data entered in cell "C8", it
will of course simply assume that cell contains a value of "0" and run the
function anyway. I want to write something like "If D90 AND C80, THEN
D9-C8"...

Anyone have any pointers???

Thanks in advance for your help!
- Chris

Hi

=IF(AND(D90,C8<""),D9-C8,"")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Chris" wrote in message
...
Hi all.
I have been trying (unsuccessfully, so far) to figure out how to write
syntax to check for missing data in two cells before executing a function.
For example, I know that I can write:

“=IF(D90, D9-C8)”

to check to make sure there is a valid case in cell "D9" before executing
the function, but the problem is if I have no data entered in cell "C8",
it
will of course simply assume that cell contains a value of "0" and run the
function anyway. I want to write something like "If D90 AND C80, THEN
D9-C8"...

Anyone have any pointers???

Thanks in advance for your help!
- Chris

Wow!
That was fast!

Thanks to you both!

Hi Chris

Another option
=IF(COUNT(D9,C8)=2,D9-C8,"")

Note that a value of 0 in either cell will return true, and the calculation
will be made, but an empty cell will return false and the result will be
null.
--
Regards
Roger Govier



"Chris" wrote in message
...
Hi all.
I have been trying (unsuccessfully, so far) to figure out how to write
syntax to check for missing data in two cells before executing a function.
For example, I know that I can write:

"=IF(D90, D9-C8)"

to check to make sure there is a valid case in cell "D9" before executing
the function, but the problem is if I have no data entered in cell "C8",
it
will of course simply assume that cell contains a value of "0" and run the
function anyway. I want to write something like "If D90 AND C80, THEN
D9-C8"...

Anyone have any pointers???

Thanks in advance for your help!
- Chris