| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IFBlank Formula
I'd like to run the following formula if Cells A11:A43
contain a blank. =IF(($A410)*(AND($B420)),$A41,"") How do I go about this? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IFBlank Formula
There is actually a ISBlank formula.
"aldricla" wrote in message ... I'd like to run the following formula if Cells A11:A43 contain a blank. =IF(($A410)*(AND($B420)),$A41,"") How do I go about this? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IFBlank Formula
Thank you... How would I write the formula to populate
the cells with =IF(($A410)*(AND($B420)),$A41,"") if they are blank using the ISBlank formula? -----Original Message----- There is actually a ISBlank formula. "aldricla" wrote in message ... I'd like to run the following formula if Cells A11:A43 contain a blank. =IF(($A410)*(AND($B420)),$A41,"") How do I go about this? Thanks! . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IFBlank Formula
Here is a formula that I use to do a calculation if the user enter something
into cell A5 =IF(NOT(ISBLANK(A5)),(E4)+(C5)-(D5),"") You would want something like this: =IF(NOT(ISBLANK(SomeCell)),(=IF(($A410)*(AND($B42 0)),$A41,"")),"") There might be a problem with the parentheses in the above, I didn't try it. "aldricla" wrote in message ... Thank you... How would I write the formula to populate the cells with =IF(($A410)*(AND($B420)),$A41,"") if they are blank using the ISBlank formula? -----Original Message----- There is actually a ISBlank formula. "aldricla" wrote in message ... I'd like to run the following formula if Cells A11:A43 contain a blank. =IF(($A410)*(AND($B420)),$A41,"") How do I go about this? Thanks! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IFBLANK | Excel Discussion (Misc queries) | |||
| ifblank function | Excel Worksheet Functions | |||
| Help IfBlank use data from next cell | Excel Worksheet Functions | |||
| if function and ifblank() function | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Hybrid Mode
