ExcelBanter - If statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If statements (https://www.excelbanter.com/excel-discussion-misc-queries/189379-if-statements.html)

Pippa

If statements

I've put in this formula into Excel =IF(AA4+AG4="","",AA4+AG4) where the
cells AA4 and AG4 are blank and I require a blank cell as a result, this will
be copied into hundreds of other cells, however i get an error #value result.
Any suggestions?

Brad

If statements

=IF(AND(ISBLANK(AA4),ISBLANK(AG4)),"",AA4+AG4)
--
Wag more, bark less

"Pippa" wrote:

I've put in this formula into Excel =IF(AA4+AG4="","",AA4+AG4) where the
cells AA4 and AG4 are blank and I require a blank cell as a result, this will
be copied into hundreds of other cells, however i get an error #value result.
Any suggestions?

All times are GMT +1. The time now is 09:47 AM.