Need formulas

[Guest]

Hello -

I have the following scenario and need the formulas:

If D37 is "Yes" then D4042 = "N/A"
If D37 is "N/A" then D3839 = "N/A"
If D37 is blank then D3842 are blank

I already have one condition for D37 - if it's zero, then turn the cell
green. I only have two conditions left.

Is there a way this can be done?

 

[Gary Keramidas]

try these:

in d40:d42 enter this:
=IF($D$37="Yes","N/A","")

in d38:d39 enter this
=IF($D$37="N/A","N/A","")


in