| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display cells when box is checked | Excel Discussion (Misc queries) | |||
| Display only certain cells | Excel Worksheet Functions | |||
| How can I conditionally add up cells and display? | Excel Discussion (Misc queries) | |||
| Formula cells needs to display "zero" | Excel Discussion (Misc queries) | |||
| Display empty cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
