Posted to microsoft.public.excel.misc

zoomzoom632 zoomzoom632 is offline

external usenet poster

Posts: 19

Another Formula Question

I want to have a cell equal the sum of two cells, only if the value of one of
the cells is greater than zero. If the value of the cell is less than or
equal to 0, i want the value of the cell to equal 0.

Example:

sum(E18:E19) if E190, or =0 if E19‰¤0.

Hope someone can help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula question	Michelle	Excel Discussion (Misc queries)	3	May 25th 07 08:02 PM
Newbie Question - Subtraction Formula Question	[email protected]	Excel Discussion (Misc queries)	3	May 5th 06 05:50 PM
Formula question	Anthony	Excel Worksheet Functions	5	January 11th 06 09:59 AM
Formula Question	Nic	Excel Discussion (Misc queries)	1	October 5th 05 01:43 AM
formula Question	danlinksman	Excel Discussion (Misc queries)	3	January 25th 05 02:07 PM

All times are GMT +1. The time now is 02:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us