“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

IF SUM OF RANGE IS MORE THAN ZERO,THEN SUM IF THE RANGE IS BLANK THEN BLANK IF THE RANGE HAS ONLY ZERO,THEN ZERO HOW SHALL I COMBINE THE ABOVE THREE IN A SINGLE CELL??

Solved by M. D. in 24 mins

HOW CAN I HAVE A =IF FORMULA SHOW A BLANK VERSES A ZERO? IE =IF(E3>1,E3*,25, ()0

Solved by G. L. in 18 mins

On tab Percent Availability Data - I would like P4:T9 to say #N/A if there is a blank, or a zero.

Solved by O. Y. in 21 mins

I need a formula that will show a zero in the average column if the cell that is calculating is blank

Solved by T. F. in 25 mins

hi, No matter what argument I put in the If statement the result is zero Ihave truied everyting possible, I want to set up an argument for if a cell is blank thenblank so I sais if(AB3="","blank","noblank")

Solved by B. B. in 28 mins