LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 788
Default syntax for "IF" commend to check for multiple empty cells bf comma

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells may look "empty" when quickly scrolling up or down DoctorG Excel Discussion (Misc queries) 2 August 21st 07 02:22 PM
"treat empty cells as" is greyed out in charts Fletch260473 Charts and Charting in Excel 1 July 8th 07 07:44 PM
Consolidating with empty-string ("") cells removed Thomas Toth Excel Worksheet Functions 7 July 5th 07 09:22 PM
"Control" plus "click" doesn't allow me to select multiple cells Ken Cooke New Users to Excel 0 September 25th 06 04:46 PM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"