if function help
If you meant display "no result" if ALL cells are empty:
=IF(SUMPRODUCT(--ISBLANK(A4:A9))=5,"no result",SUM(A5:A9)+A4*3)
If you want to display "no result" if ANY of the cells are empty:
=IF(SUMPRODUCT(--ISBLANK(A4:A9))0,"no result",SUM(A5:A9)+A4*3)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Haz" wrote:
Hi,
I would like to return 'no result' if the cells in the sum below are empty.
=sum(a5:a9)+(a4*3)
I think I need an if function in the sum above so if all cells
A4,A5,A6,A7,A8 & A9 have no values in then give 'no result''. If any of these
cells have a value which may come to 0 then give 0 or any other value of the
sum.
hope this clear I can't get this to work
Thanks
|