Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX() and MIN()
Hi Excellers,
Can anyone suggest a solution for the following. I want to test C5 in D5 and E5 using the MAX() and MIN() functions. Dependent on the result Excel puts a Zere in the opposite Cell. eg. in E5 will be a Zero because C5 is positive. How can I get Excel to put a blank in this cell ( or any cell ) that does not satisy the MAX() or MIN() argument. I know how to do it using the IF( ) statement,but the MAX & MIN are new to me..... All help gratefully accepted ROW C D E 5 99 =MAX(0,C5) =MIN(0,C5) 6 -50 =MAX(0,C6) =MIN(0,C6) 7 45 =MAX(0,C7) =MIN(0,C7) 8 -54 =MAX(0,C8) =MIN(0,C8) 9 -54 =MAX(0,C9) =MIN(0,C9) |