Only perform formula if another cell is non-blank

Hi again everyone.

Thanks to everyone for helping with my previous problem (here) but I've now got another problem with the same spreadsheet.

I am trying to get an if formula to only return a value is a cell (that is the second part of the if) is non blank as well. I've tried with several permutations of IF's/AND's but cannot get it to work.

=IF(C5="","",IF(J5="No",0.1,1)) < the formula currently in cell K5, but I also want it to stay blank if J5 (which is data validated to either be blank, Yes or No answers) is blank too. Theoretically I could add a further IF statement to the front but Excel won't do that many IF's in one go.

Have given myself a small logic headache trying to solve this this morning!

Originally Posted by Fotis1991

This must works.

=IF(or(C5="",j5=""),"",IF(J5="No",0.1,1)))

Perfect, you made it look easy as well, thanks very much

(will mark thread as solved)