| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning blank cell when conditions not met
Entered into G7 the following =IF(F7<3,3-F7,0) F7 is the SUM of C7,D7,E7 If there are no entries in C7,D7 and E7 I want G7 to be blank. meaning until there are numbers entered I don't want to see 0 in G7 Any ideas. Since i can't seem to find a way to put in an else statement with excel 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
returning blank cell when conditions not met
Try
=IF(AND(LEN(C7)0,LEN(D7)0,LEN(E7)0),IF(F7<3,3-F7,0),"") Hope this helps, Hutch "kfarley" wrote: Entered into G7 the following =IF(F7<3,3-F7,0) F7 is the SUM of C7,D7,E7 If there are no entries in C7,D7 and E7 I want G7 to be blank. meaning until there are numbers entered I don't want to see 0 in G7 Any ideas. Since i can't seem to find a way to put in an else statement with excel 2003 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
returning blank cell when conditions not met
=if(count(c7,d7,e7)<3,"",if(f7<3,3-f7,0))
or =if(count(c7,d7,e7)<3,"",max(3-f7,0)) kfarley wrote: Entered into G7 the following =IF(F7<3,3-F7,0) F7 is the SUM of C7,D7,E7 If there are no entries in C7,D7 and E7 I want G7 to be blank. meaning until there are numbers entered I don't want to see 0 in G7 Any ideas. Since i can't seem to find a way to put in an else statement with excel 2003 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
returning blank cell when conditions not met
With this entered in cell G7
=IF(AND(C7="",D7="",E7=""),"",IF(F7<3,3-F7,0)) if C7:E7 are blank, G7 should be blank as well.... but with your formula, you should have seen 3 in the cells with no entries in C7:E7. if you want F7 to be blank instead of displaying a zero, in cell F7 enter the following formula: =IF(AND(C7="",D7="",E7=""),"",SUM(C7:E7)) "kfarley" wrote: Entered into G7 the following =IF(F7<3,3-F7,0) F7 is the SUM of C7,D7,E7 If there are no entries in C7,D7 and E7 I want G7 to be blank. meaning until there are numbers entered I don't want to see 0 in G7 Any ideas. Since i can't seem to find a way to put in an else statement with excel 2003 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
returning blank cell when conditions not met
Thanks guys I'll give it a try.
"kfarley" wrote: Entered into G7 the following =IF(F7<3,3-F7,0) F7 is the SUM of C7,D7,E7 If there are no entries in C7,D7 and E7 I want G7 to be blank. meaning until there are numbers entered I don't want to see 0 in G7 Any ideas. Since i can't seem to find a way to put in an else statement with excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a Value if 3 Conditions are True | Excel Worksheet Functions | |||
| Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
| returning blank cell | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
| Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
Linear Mode
