IF/OR Statement needed
/Hi to all
I have a MAX statement that I think I need to add an If/Or statement in front of to return a blank if the cell shows either a blank, a minus amt, or a 0. Can someone please tell me how to write this part? Thanks much -- smither fan |
IF/OR Statement needed
Ross,
Maybe this =IF(MAX(A1:A5)<=0,"",MAX(A1:A5)) Mike "Ross" wrote: /Hi to all I have a MAX statement that I think I need to add an If/Or statement in front of to return a blank if the cell shows either a blank, a minus amt, or a 0. Can someone please tell me how to write this part? Thanks much -- smither fan |
IF/OR Statement needed
Hi Mike
Thanks for the input. The first part of your formula-=IF(MAX(A1:A5)<=0,"",-worked for me. When I tried to use the whole piece, then my part of the formula wouldn't calculate correctly. Also, I managed to put together an IF/OR statement for the beginning that worked also. Thanks again! -- smither fan "Mike H" wrote: Ross, Maybe this =IF(MAX(A1:A5)<=0,"",MAX(A1:A5)) Mike "Ross" wrote: /Hi to all I have a MAX statement that I think I need to add an If/Or statement in front of to return a blank if the cell shows either a blank, a minus amt, or a 0. Can someone please tell me how to write this part? Thanks much -- smither fan |
All times are GMT +1. The time now is 12:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com