| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Formatting
To make all of this 2nd part of my question simple.......
How does one enter "(If (B#)OR(C#) is blank, or whatever you would use here) THEN D# is also blank If that makes any sense to any of you experts Jam |
|
#2
|
|||
|
|||
|
The heading says Cell formating but you question is about the cell content.
However if you want say cell D1 to be blank if either B1 is blank or C1 is blank and othewise you want to give it a value of 10 then in cell D1 you enter the following formula =if(OR(B1="",C1=""),"",10) Alok Joshi "Jambora" wrote: To make all of this 2nd part of my question simple....... How does one enter "(If (B#)OR(C#) is blank, or whatever you would use here) THEN D# is also blank If that makes any sense to any of you experts Jam |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Special cell formatting | Excel Discussion (Misc queries) | |||
| Formatting a cell to populate on a certain date | Excel Worksheet Functions | |||
| Conditional Formatting Cell and Row | Excel Worksheet Functions | |||
| Formatting dates in the future | Excel Worksheet Functions | |||
Linear Mode
