Blank fields

[reddcannon]

I have a spreadsheet excel 16 64 bit windows 10 here is my problem, I want cell G17 to return null value, if cells C3:C5 are blank

Here is what is in G17 =ROUNDDOWN((C17/8),0.2)
Here is what is in C17 just the number 75 that I type in as needed

I have tried if statements, Sumproduct if sum of is "" etc nothing works.
Can someone please help an old man before I lose the rest of what mind I have left

 

[Sufiyan97]

Try

=IF(AND(C3="",C4="",C5=""),"",ROUNDDOWN((C17/8),0.2))

 

[xlhelp15]

How about,

=IF(COUNTBLANK(C3:C5)>0,(ROUNDDOWN((C17/8),0.2)),"")

 

[reddcannon]

How about,

=IF(COUNTBLANK(C3:C5)>0,(ROUNDDOWN((C17/8),0.2)),"")

it quit working , c3:c5 are blank but it still returns 6 in G17

 

[reddcannon]

How about,

=IF(COUNTBLANK(C3:C5)>0,(ROUNDDOWN((C17/8),0.2)),"")

it quit working, c3:c5 is blank but it still is putting a total in G17

 

[Sufiyan97]

it quit working, c3:c5 is blank but it still is putting a total in G17

have you tried formula in post #2?

 

[reddcannon]

it quit working , c3:c5 are blank but it still returns 6 in G17

have you tried formula in post #2?

Yes only works once

 

[reddcannon]

Try

=IF(AND(C3="",C4="",C5=""),"",ROUNDDOWN((C17/8),0.2))

now it works thanks so much

 

[Sufiyan97]

You're welcome!
Glad we could help.

 

[reddcannon]

now it works thanks so much

It works perfect now. Thanks so much. Got busy picking grandkids up from
School