What conditional excel formula should I use?

[samdighe]

I am a newbie in excel. Please refer my excel workbook snapshot below:

<tbody>
</tbody>

Currently the formula I have is such that if D137 and E137 are blank, then F137 is also blank. However, if the values in D137 and E137 are identical, then F137 shows 'Correct' and if the values are different then F137 shows 'Wrong'. I want to add one more condition without changing any of the previous conditions. The new condition is, If D137 is blank but there is a value in E137, then F137 should show 'Wrong'. How do I edit my formula to do that?

The current formula is pasted below:

=IF(OR(ISBLANK(D137),ISBLANK(E137)),"",IF(D137=E137, "Correct", "Wrong"))

Thanks.

 

[Swapnil Shah]

Use as below

=IF(And(ISBLANK(D137),ISBLANK(E137)),"",IF(D137=E137, "Correct", "Wrong"))