ExcelBanter - =SF

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

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

- - =SF_Load!A2 (https://www.excelbanter.com/excel-discussion-misc-queries/251785-%3Dsf_load-a2.html)

Jim

=SF_Load!A2

Hello,

how would I change this formula (=SF_Load!A2) so it shows a nothing if the
cell it's refeerencing is blank. It currently shows 0.

Thanks

FSt1

=SF_Load!A2

hi
=if(SF_Load!A2="","",SF_Load!A2)

regards
FSt1

"Jim" wrote:

Hello,

how would I change this formula (=SF_Load!A2) so it shows a nothing if the
cell it's refeerencing is blank. It currently shows 0.

Thanks

Dave Peterson

=SF_Load!A2

=if(sf_load!a2="","",sf_load!a2)

Jim wrote:

Hello,

how would I change this formula (=SF_Load!A2) so it shows a nothing if the
cell it's refeerencing is blank. It currently shows 0.

Thanks

--

Dave Peterson

All times are GMT +1. The time now is 07:16 PM.