Hello -

I have the following scenario and need the formulas:

If D37 is "Yes" then D40:D42 = "N/A"
If D37 is "N/A" then D38:D39 = "N/A"
If D37 is blank then D38:D42 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?
--
Sandy

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

--


Gary


"Sandy" wrote in message
...
Hello -

I have the following scenario and need the formulas:

If D37 is "Yes" then D40:D42 = "N/A"
If D37 is "N/A" then D38:D39 = "N/A"
If D37 is blank then D38:D42 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?
--
Sandy