ExcelBanter - how to get excel to display blank if reference cell blank

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

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

- - how to get excel to display blank if reference cell blank (https://www.excelbanter.com/excel-worksheet-functions/58431-how-get-excel-display-blank-if-reference-cell-blank.html)

silent1(not)

how to get excel to display blank if reference cell blank

I'm trying to get a blank if a refernce cell is blank or perform calculation
using the reference cell if there is an entry in the ref cell

Peo Sjoblom

how to get excel to display blank if reference cell blank

=IF(Sheet1!A1="","",Sheet1!A1*250)

as an example

--

Regards,

Peo Sjoblom

"silent1 (not)" wrote in message
...
I'm trying to get a blank if a refernce cell is blank or perform
calculation
using the reference cell if there is an entry in the ref cell

All times are GMT +1. The time now is 06:50 AM.