ExcelBanter - if question

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

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

- - if question (https://www.excelbanter.com/excel-discussion-misc-queries/204021-if-question.html)

Matt

if question

I have a cell wich has =sum(K5-J5) if the answer is 0 how can I get the
cell to be blank?

Jim Thomlinson

if question

=if(k5=j5, "", k5-j5)
--
HTH...

Jim Thomlinson

"Matt" wrote:

I have a cell wich has =sum(K5-J5) if the answer is 0 how can I get the
cell to be blank?

muddan madhu

if question

try this

=IF(K5-J5=0,"",K5-J5)

On Sep 26, 1:35*am, Matt wrote:
I have a cell wich has =sum(K5-J5) * if the answer is 0 how can I get the
cell to be blank?

Matt

if question

That worked great Thanks for the help

"Matt" wrote:

I have a cell wich has =sum(K5-J5) if the answer is 0 how can I get the
cell to be blank?

All times are GMT +1. The time now is 07:41 AM.