Hi, I am look to make my data entry spreadhseet a little neater. I have two columns of data with a column to the right to list the maximum value between them. So a simple =MAX(C2:C3) will work but leaves a 0 in the max value cell. I think you can use the ISBLANK function but i’m not sure how to put this within the formula. So what I want the cell to do is: If there is no data within C2:C3 then stay blank, if there is data then do the MAX function. It should be very straightforward but having a mental block.

## You might also find helpful in Excel...

Hi!!

Try this formula…

`=IF(MAX(C2:C3)=0,"",MAX(C2:C3))`

What the formula does is if the Max number is 0 then display blank, otherwise display the maximum number.

Hope it helps…?

Awesome thanks!