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

=IF(A1+B1>1,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.
"D Loafman" <D (E-Mail Removed)> wrote in message
news:35425FC2-29A4-4C48-9D61-(E-Mail Removed)...
> 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

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+B1>1,A1+B1,"Zero,"" or Error Message")
> Regards,
> Alan.
> "D Loafman" <D (E-Mail Removed)> wrote in message
> news:35425FC2-29A4-4C48-9D61-(E-Mail Removed)...
> > Need Excel formula to display sum total only if total greater than 1
>
>
>

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)

"D Loafman" <(E-Mail Removed)> wrote in message
news:2FE147CB-A3BC-470C-B588-(E-Mail Removed)...
> 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+B1>1,A1+B1,"Zero,"" or Error Message")
> > Regards,
> > Alan.
> > "D Loafman" <D (E-Mail Removed)> wrote in message
> > news:35425FC2-29A4-4C48-9D61-(E-Mail Removed)...
> > > Need Excel formula to display sum total only if total greater than 1
> >
> >
> >

=IF(A1+B1>1,A1+B1,"")
Alan.
"D Loafman" <(E-Mail Removed)> wrote in message
news:2FE147CB-A3BC-470C-B588-(E-Mail Removed)...
>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+B1>1,A1+B1,"Zero,"" or Error Message")
>> Regards,
>> Alan.
>> "D Loafman" <D (E-Mail Removed)> wrote in message
>> news:35425FC2-29A4-4C48-9D61-(E-Mail Removed)...
>> > Need Excel formula to display sum total only if total greater than 1
>>
>>
>>