|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 19th, 2010, 05:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
replace a negative result with a zero?
I have my formula entered but need it to return a zero if the result is
negative. Any help is greatly appreciated. -- Pam 
|
|
#2
April 19th, 2010, 05:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace a negative result with a zero?
Well, what is the formula that you are using?
You could try this: =MAX(your_formula,0) to replace your_formula. Hope this helps. Pete On Apr 19, 5:17*pm, Pam2277 wrote: I have my formula entered but need it to return a zero if the result is negative. *Any help is greatly appreciated. -- Pam
|
|
#3
April 19th, 2010, 05:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
replace a negative result with a zero?
Hi,
=if(your formula0,0,your formula) "Pam2277" wrote: I have my formula entered but need it to return a zero if the result is negative. Any help is greatly appreciated. -- Pam
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
