Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Max function to formula to enter 0 if <0
How can I do this without creating a circular reference?
Thanks, Wayne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Max function to formula to enter 0 if <0
What is what you are exactly doing? For that type of conditions, usually the
IF formula may help, but you haven't explained what you need to achieve and where the circular reference arises. Miguel. "O Wayne" wrote: How can I do this without creating a circular reference? Thanks, Wayne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Max function to formula to enter 0 if <0
Hi
Use something like this: =MAX(0,yourformula) If your formula is less than zero, this will return sero. If it's more than zero, it will return the formula result Hope this helps. Andy. "Miguel Zapico" wrote in message ... What is what you are exactly doing? For that type of conditions, usually the IF formula may help, but you haven't explained what you need to achieve and where the circular reference arises. Miguel. "O Wayne" wrote: How can I do this without creating a circular reference? Thanks, Wayne |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Max function to formula to enter 0 if <0
=If(MAX(data)<0,0,MAX(data))
Jerry "O Wayne" wrote: How can I do this without creating a circular reference? Thanks, Wayne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
IF Function to test formula in a cell | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions |