Cells display nothing IF
 

I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

Hi,

Try something like below:

=IF(your formula<0,"",yourformula)

Thanks,
--
Farhad Hodjat


"kim" wrote:

I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!

"Peo Sjoblom" wrote:

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!


"Farhad" wrote:

Hi,

Try something like below:

=IF(your formula<0,"",yourformula)

Thanks,
--
Farhad Hodjat


"kim" wrote:

I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

try =if(days360(B274,L274)<=0,"",days360(B274,L274))

"kim" wrote:

The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!

"Peo Sjoblom" wrote:

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

If you only want to hide the negative number you can use my solution
You need to do formatcellsnumber and select custom and put in either
General; or 0.00;

You can also change your formula to

=IF(COUNT(B274,L274)=2,DAYS360(B274,L274),0)

or

=IF(COUNT(B274,L274)=2,DAYS360(B274,L274),"")

depending on if you want zero or blank


--
Regards,

Peo Sjoblom



"kim" wrote in message
...
The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!

"Peo Sjoblom" wrote:

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if
the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

It tells me I have an inconsistent formula. Maybe it's not possible...?

"bj" wrote:

try =if(days360(B274,L274)<=0,"",days360(B274,L274))

"kim" wrote:

The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!

"Peo Sjoblom" wrote:

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?

Cells display nothing IF
 

That did it! THANK YOU!!!! I appreciate all of your help!


"Peo Sjoblom" wrote:

If you only want to hide the negative number you can use my solution
You need to do formatcellsnumber and select custom and put in either
General; or 0.00;

You can also change your formula to

=IF(COUNT(B274,L274)=2,DAYS360(B274,L274),0)

or

=IF(COUNT(B274,L274)=2,DAYS360(B274,L274),"")

depending on if you want zero or blank


--
Regards,

Peo Sjoblom



"kim" wrote in message
...
The formula in my cells is :

=DAYS360(B274,L274)

I keep getting an error when I try to do something different. Is this
possible?

Thank you so much!

"Peo Sjoblom" wrote:

Custom format

General;

will only display zero and greater


using the same for a 2 decimal number format

0.00;

add a semicolon to the end if you don't want to display zero

0.00;;


--
Regards,

Peo Sjoblom


"kim" wrote in message
...
I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative
number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if
the
value is less than 0 nothing is displayed in the cell?