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