MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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