formula to return blank cell if conditions not met

[defender]

Hi all,

I'm using the formula below in my workbook and in the cell its returned the value 0. I want the formula to leave the cell blank rather than with an 0 unless the condition is met. I have tried using "" at the end of the formula but this is not working.

=IF(D8="OOH(SET)",C8)+(IF(D8="OOH(T1)",C8))+(IF(D8="OOH(T2)",C8))+(IF(D8="OOH(T5)",C8))+(IF(D8="OOH(LTR)",C8))+(IF(D8="OOH(T4)",C8))+(IF(D8="Top up",C8))

 

[Jonmo1]

Try

=IF(OR(D8={"OOH(SET)","OOH(T1)","OOH(T2)","OOH(T5)","OOH(LTR)","OOH(T4)","Top up"}),C8,"")

 

[macattackpro]

Hello,

Each of your IF statements do not have an ELSE identified so if the formula does not meet the IF conditions it will return FALSE, or 0 when doing addition.

 

[defender]

Thanks

 

[Jonmo1]

You're welcome.