Conditional Excel formula

[Guest]

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

 

[Alan]

=IF(A1+B1>1,A1+B1,"Zero,"" or Error Message")
Regards,
Alan.

 

[Guest]

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

 

[Guest]

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.

 

[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)

 

[Alan]

=IF(A1+B1>1,A1+B1,"")
Alan.

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.