Make a cell blank given a code

[Mel]

I am trying to achieve a blank cell which currently has a formula relating
to a different sheet.



On sheet named "week"

In cell M32 I have the following code





=IF(OR(D33>0,G33>0),'Stats-Job'!M9,)





However if the code M is in another cell, at say H32, then I want the cell
M32 to remain blank,



Any help appreciated.



Mel

 

[Don Guillett]

just wrap in another if
=if(h32="M","", yourformula)

 

[Mel]

BTW, I have tried this but it gives me a value error

=IF(OR(D33>0,G33>0),'Stats-Job'!M9,)*IF(H32="M","")

Its after midnight here in Melbourne Australia, but I'm still up working. I
would appreciate anyone who knows how I fix this problem.
I may need to go to bed soon but thank anyone who can help and will look in
the morning.
Thank you

 

[Mel]

Hi Don, and thanks, I've tried this

=IF(H32="M","",IF(OR(D33>0,G33>0),'Stats-Job'!M9,))
but now if there is no "M" in the cell it gives me a "ref" error?/

Mel

 

[Don Guillett]

try this

=IF(OR(h32<>"m",D33>0,G33>0),'Stats-Job'!M9,"")

 

[Don Guillett]

=IF(OR(h32="M",D33<=0,G33<=0),"",'Stats-Job'!M9)

 

[Mel]

Don, Many thanks for your help,

=IF(H32="M","",IF(OR(D33>0,G33>0),'Stats-Job'!M9,))

Which is what you were trying to tell me in your first post, I got the
spelling wrong on my reference to the other sheet, too long out of bed and
fingers cold and typed the wrong sheet name, I thank you very much for
helping me. Bed time in eastern Australia.

Mel