Add two cells if one cell is greater than 0

's Computer Specifications

I am looking to add cells 'a' and 'b' if cell 'a' is greater than '0'. If
cell 'a' is less than or equal to '0', I would like the value to be 0. Any
help would be appreciated.

Thanks
Drew

's Computer Specifications

Hi Drew

=IF(A1<=0,0,A1+B1)

--
Regards
Roger Govier

"qh8519a" <(E-Mail Removed)> wrote in message
news:77A44FC9-E669-4B34-AB8C-(E-Mail Removed)...
> I am looking to add cells 'a' and 'b' if cell 'a' is greater than '0'. If
> cell 'a' is less than or equal to '0', I would like the value to be 0.
> Any
> help would be appreciated.
>
> Thanks
> Drew

's Computer Specifications

Try,

=IF(A1<=0,0,A1+B1)

Mike

"qh8519a" wrote:

> I am looking to add cells 'a' and 'b' if cell 'a' is greater than '0'. If
> cell 'a' is less than or equal to '0', I would like the value to be 0. Any
> help would be appreciated.
>
> Thanks
> Drew

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
subtracting 2 cells but only if 1st cell is greater than 0	Maureen	Microsoft Excel Worksheet Functions	1	20th Jan 2010 11:31 PM
I want the greater number of 2 cells to show in a separate cell	=?Utf-8?B?Y2Zpc2Vy?=	Microsoft Excel Misc	2	16th Nov 2005 10:32 PM
RE: I want the greater number of 2 cells to show in a separate cell	=?Utf-8?B?Um9uIENvZGVycmU=?=	Microsoft Excel Misc	1	16th Nov 2005 09:22 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	Microsoft Excel New Users	2	9th Dec 2004 02:06 AM
Turn cell red if today is greater or equal to date in cell	Rich	Microsoft Excel New Users	2	7th Dec 2004 10:50 PM