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

hi how to calculate averageif in excel pivot if value is zero.

Solved by G. U. in 11 mins

i need formula if cell a2 = zero or value than cell b2=result will be zero or cell a-9 if more than 0 cell c2=if cell a2 zero or value than zero or cell a2-cell b2

Solved by K. H. in 14 mins

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

In an income targets sheet i have a "target" and an "actual" column. I want a percentage to show how much of the 'target' the actual has met, but if the target was original zero i want the percentage to show 100% for any 'actual' above zero, and zero if both columns are zero. Problem i have if just using percent columns = actual/target and both are zero it show an error?

Solved by E. A. in 16 mins

Hi, What is the formula in excel to calculate the number of days between two cells, with dates in them, excluding weekdays and holidays, if the number is greater than zero, or return zero if it is not (if the two dates are the same)? Thanks, Rose

Solved by D. Q. in 22 mins