Conditional Formula Request

[fishin]

I would greatly appreciate help with formulas to address the following two conditions:

1). The recipient cell is to equal the value posted to cell F82if cell F83 = “CRITICAL” and cell M83 = “X” …..if these conditions are not metthe recipient cell is to remain blank.

2). Therecipient cell is to equal the value posted to cell G83 on a worksheetidentified as QC W Beam if onthat same worksheet (QC W Beam),cell F83 = “CRITICAL” and cell M83 = “X”, otherwise the recipient cell is toremain blank

 

[Norie]

Try this.

=IF(AND(F83="CRITICAL", M83="X"), F82, IF(AND('QC W Beam'!F83="CRITICAL", 'QC W Beam'!M83="X"), 'QC W Beam'!G83, ""))

 

[JoeMo]

I assume you want two separate formulas:
1. =IF(AND(F83="CRITICAL",M83="X"),F82,"")
2. =IF(AND('QC W Beam'!F83="CRITICAL",'QC W Beam'!M83="X"),'QC W Beam'!G83,"")

 

[fishin]

I assume you want two separate formulas:
1. =IF(AND(F83="CRITICAL",M83="X"),F82,"")
2. =IF(AND('QC W Beam'!F83="CRITICAL",'QC W Beam'!M83="X"),'QC W Beam'!G83,"")

THANK YOU SIR...THAT IS EXACTLY WHAT I WAS LOOKING FOR. WORKS GREAT!

Much Appreciated,

Dave S

 

[fishin]

Thanks for your quick response. It works great. I was however in search of two separate statements.

 

[JoeMo]

THANK YOU SIR...THAT IS EXACTLY WHAT I WAS LOOKING FOR. WORKS GREAT!

Much Appreciated,

Dave S

You are welcome - thanks for the reply.