Need Excel formula to display sum total only if total greater than 1

=IF(A1+B11,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.
"D Loafman" <D wrote in message
...
Need Excel formula to display sum total only if total greater than 1

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.

"Alan" wrote:

=IF(A1+B11,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.
"D Loafman" <D wrote in message
...
Need Excel formula to display sum total only if total greater than 1

Use conditional formatting.

Select the cell

Goto FormatConditional Formatting

Change Conditions 1 to Formula Is

Add a formula of =A11

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)

"D Loafman" wrote in message
...
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.

"Alan" wrote:

=IF(A1+B11,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.
"D Loafman" <D wrote in message
...
Need Excel formula to display sum total only if total greater than 1

=IF(A1+B11,A1+B1,"")
Alan.
"D Loafman" wrote in message
...
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.

"Alan" wrote:

=IF(A1+B11,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.
"D Loafman" <D wrote in message
...
Need Excel formula to display sum total only if total greater than 1

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),"")

"D Loafman" wrote:

Need Excel formula to display sum total only if total greater than 1