ExcelBanter - Making formula results not visible in a cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Making formula results not visible in a cell (https://www.excelbanter.com/excel-worksheet-functions/186593-making-formula-results-not-visible-cell.html)

mp smith

Making formula results not visible in a cell

In my "total" column I don't want the results of the SUM to show up if there
is not an entry in the cell to the left of the SUM cell.
--
MPS

David Biddulph[_2_]

Making formula results not visible in a cell

=IF(A101="","",SUM(B1:B100))
--
David Biddulph

"mp smith" wrote in message
...
In my "total" column I don't want the results of the SUM to show up if
there
is not an entry in the cell to the left of the SUM cell.
--
MPS

T. Valko

Making formula results not visible in a cell

Try something like this:

=IF(A10="","",SUM(.....))

--
Biff
Microsoft Excel MVP

"mp smith" wrote in message
...
In my "total" column I don't want the results of the SUM to show up if
there
is not an entry in the cell to the left of the SUM cell.
--
MPS

All times are GMT +1. The time now is 11:58 AM.