solution for the blank cell using the IF function

**Jason Eric** · 08-23-2013, 10:30 AM

=IF(OR(ISBLANK(B3),ISBLANK(C3),ISBLANK(D3)),"Correct",IF(D3=B3+C3,"Correct","Wrong"))

**ragnaedge** · 08-23-2013, 10:40 AM

Originally Posted by Jason Eric

=IF(OR(ISBLANK(B3),ISBLANK(C3),ISBLANK(D3)),"Correct",IF(D3=B3+C3,"Correct","Wrong"))

the only cell that is blank is D3 it should be left blank to input the answers...

ive tried your formula but it seems when i left the cell blank it shows correct what i wanted is when D3 is blank the cell where the formula is should be blank too using this formula =IF(D3=B3+C3,"Correct","Wrong")