LEAVE BLANK IF NEGATIVE

C

Carolan

I know this can be done.....just don't know how. Trying to create a formula
that would leave the cell Column C1 empty if the result of Column A1
minus-Column B1 is negative. If A1 -B1 is positive it would enter the
result. Help please!!!!

If A1 - B1 = Positive figure, enter the result in C1
If A1 - B1 = Negative figure, do not enter result in C1
 
R

RagDyeR

Try this:

=IF(MAX(A1-B1,0)=0,"",A1-B1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I know this can be done.....just don't know how. Trying to create a formula
that would leave the cell Column C1 empty if the result of Column A1
minus-Column B1 is negative. If A1 -B1 is positive it would enter the
result. Help please!!!!

If A1 - B1 = Positive figure, enter the result in C1
If A1 - B1 = Negative figure, do not enter result in C1
 

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

Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Referencing the values of multiple cells in conditinal formatting. 0
Nameing a function 1
% Variance 10
Find partial text and retrun value in corresponding column 3
SUMIF with criteria "<>" & "=" 4
Countifs with different restrictions 1
Excel Formula and Variance Analysis 0

Top