Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells may look "empty" when quickly scrolling up or down | Excel Discussion (Misc queries) | |||
"treat empty cells as" is greyed out in charts | Charts and Charting in Excel | |||
Consolidating with empty-string ("") cells removed | Excel Worksheet Functions | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |