Help with OR/AND with IF

[Xirom431]

Hi,

Thank you in advance for the help. I have 4 Columns

2

1

Open

1

1

2

Open

1

If either column A or B is greater than 1, Column C will show Open. I got that far. However, I need help with D Column. I would like to show the different between Column A and B when Column C is Open. If A or B is blank, C and D should be blank.

Thanks,

 

[Joe4]

Glad you got a solution.
We probably could have helped you a few days ago if you had answered the clarification questions I asked.