Here are some problems that our users have asked and received explanations on
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")