Hey everybody,
I'm trying to work out a way to keep some cells blank when there's no data in them. I'm using the =Max(B4:F4) function to get the largest number in the row, but I'd like the cell that displays the max number (G4) to be blank when there's no data inputted in the row. I've tried everything I can think of, but to no avail. Does anyone have any suggestions?
Try this...
=IF(COUNT(B4:F4),Max(B4:F4),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony,
Out of interest how does the 'logical test' element work? I'm struggling to understand how the IF statement would equate a count with a TRUE/FALSE output when you're not comparing it to anything, e.g >0? Does it regard anything 1 and above as TRUE and all 0's FALSE?
Regards,
Snook
Last edited by The_Snook; 10-06-2016 at 10:22 AM.
In this application, yes, as the count can only be an integer.Originally Posted by The_Snook
Technically, ANY number other than 0 will evaluate as TRUE and 0 will evaluate as FALSE.
1 = TRUE
7 = TRUE
0.5 = TRUE
0.000000000001 = TRUE
0 = FALSE
Interesting, cheers.
-------------
That worked beautifully.
Thank you very much.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks