D
D Loafman
Need Excel formula to display sum total only if total greater than 1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan
=IF(A1+B1>1,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.
Regards,
Alan.
E
Esther
Hi,
Try this out. It works on my end, and just put in your own data range in
place of my example.
=IF(SUM(O63:O123)>0,SUM(O63:O123),"")
Try this out. It works on my end, and just put in your own data range in
place of my example.
=IF(SUM(O63:O123)>0,SUM(O63:O123),"")
D
D Loafman
I get "FALSE" displayed in cell for positive number - I want the number to
be displayed only if greater than 1 - I don't want True/False to be
displayed. Hope you can help.
be displayed only if greater than 1 - I don't want True/False to be
displayed. Hope you can help.
B
Bob Phillips
Use conditional formatting.
Select the cell
Goto Format>Conditional Formatting
Change Conditions 1 to Formula Is
Add a formula of =A1>1
Click Font
Select the colour white from the dropdown
OK out
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
Select the cell
Goto Format>Conditional Formatting
Change Conditions 1 to Formula Is
Add a formula of =A1>1
Click Font
Select the colour white from the dropdown
OK out
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
A
Alan
=IF(A1+B1>1,A1+B1,"")
Alan.
Alan.
D Loafman said:I get "FALSE" displayed in cell for positive number - I want the number to
be displayed only if greater than 1 - I don't want True/False to be
displayed. Hope you can help.