Forum Discussion
if function in excel
Hi, how to hide the 0 in the red circle?? Is the formula used correct??
Hi Abu Mohammad,
You have to check if the sum of the range is equal to 0, not equal to "" .
So please use this formula in column W:
=IF(SUM(C11:V11)=0,"",SUM(C11:V11))
Regards
thank you very much sir Haytham Amairah
