Ignoring blank cells

[Yonex1975]

I am working on a project using the below IF statement but need it to not calculate if the cell is blank.

=IF(C4<=375,"100%",IF(C4<=405,"90%",IF(C4<=450,"80%",IF(C4<=475,"70%",IF(C4<=600,"50%",IF(C4>=601,"0%",0))))))

How do I make that happen??/

Thanks

[FDibbins]

Hi and welcome to the forum

try this...
=IF(C4="","",IF(C4<=375,"100%",IF(C4<=405,"90%",IF(C4<=450,"80%",IF(C4<=475,"70%",IF(C4<=600,"50%",IF(C4>=601,"0%",0)))))))

But then you also need to adjust the formula in column F, but thai is protected, so it is not visible

Also, in your formula...
=IF(C4="","",IF(C4<=375,"100%",IF(C4<=405,"90%",IF(C4<=450,"80%",IF(C4<=475,"70%",IF(C4<=600,"50%",IF(C4>=601,"0%",0)))))))
is 405 correct? it seems to not be in the same sequence as the other values, maybe it should be 400?

[Yonex1975]

Hi and welcome to the forum

try this...
=IF(C4="","",IF(C4<=375,"100%",IF(C4<=405,"90%",IF(C4<=450,"80%",IF(C4<=475,"70%",IF(C4<=600,"50%",IF(C4>=601,"0%",0)))))))

But then you also need to adjust the formula in column F, but thai is protected, so it is not visible

Also, in your formula...
=IF(C4="","",IF(C4<=375,"100%",IF(C4<=405,"90%",IF(C4<=450,"80%",IF(C4<=475,"70%",IF(C4<=600,"50%",IF(C4>=601,"0%",0)))))))
is 405 correct? it seems to not be in the same sequence as the other values, maybe it should be 400?

Why do I need to adjust the formula, =(D4*0.5)+(E4*0.5), in Column F?

[FDibbins]

Because it gives errors (actually ###### is what shows, but maybe the column wasnt wide enough?)

[Yonex1975]

Ok..yea it was just the information that was in cells D4 and E4 were not completed. I am just working on making sure it is not calculating blank cells as a zero right now. Your suggestion above worked perfectly for the AHT% formula. I am assuming I can apply that same principal to almost any formula?

[Yonex1975]

Using the below forumla how do I keep it from looking at blank cells as a Zero.

=HOUR('December Team RollUp'!C4)*3600+MINUTE('December Team RollUp'!C4)*60+SECOND('December Team RollUp'!C4)

Thanks

Yonex

[martindwilson]

=if('December Team RollUp'!C4="","",MOD('December Team RollUp'!C4,1)*86400)

[Yonex1975]

Thank you, that worked perfectly!!!!!!

[Yonex1975]

I must say I hate all these cells that are blank till later in the month.

I am pulling information from another page using ='December Team RollUp'!F4 but I don't need it to pull anything until an average is put in that field. It is now pulling as zero which is messing with other calculations

How do I accomplish this one?