if function help
If any of these cells have a value which may
come to 0 then give 0
Not real sure what "which may come to 0" means.
See if this does what you want:
=IF(COUNT(A5:A9)=0,"No Result",IF(COUNTIF(A5:A9,0),0,SUM(A5:A9,A4*3)))
--
Biff
Microsoft Excel MVP
"Haz" wrote in message
...
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
|