how set cell to blank?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell formula:
=IF(OR(ISBLANK(K10),ISBLANK(L10)),,L10-K10)
Which makes the cell zero if either of k10 or l10 is blank, (and subtracts
the two if not), but I want to make the cell blank rather than zero.
Thanks again.
 
One way:

=IF(OR(ISBLANK(K10),ISBLANK(L10)),"",L10-K10)

alternatively:

=IF(COUNT(K10:L10)<2,"",L10-K10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nested if 6
Unique Record retrieval. 2
Function VBA - 3 variables 2
Overtime Calculation 16
Nested IF functions 5
Conditional format order priority 2
Nested If Statement - Help! 3
Validation Formula 1

Back
Top