Nothing in return
Posted by Patrick on May 13, 2001 6:36 PM
This max formula can return a zero value for me.....
how can I have it return nothing " "......
if the value it is returning is zero
=MAX('Enter Records Here'!AA2:AA6)
thanks
Patrick
Posted by Mark W. on May 13, 2001 7:42 PM
=IF(MAX('Enter Records Here'!AA2:AA6),MAX('Enter Records Here'!AA2:AA6),"")
Posted by Patrick on May 13, 2001 7:53 PM
Perfect.....
thanks once again!!!!!!!
