Multiple IF formula help!

Copper Contributor

Hello!

It’s been l since college that I’ve worked with Excel and I was by no means an expert then! I am trying to write a multiple IF formula. I’m writing a formula in cell R1 and would like to say .. 

 

if L1 is blank, then leave R1 blank also, but if L1 is not blank, then M1-L1

 

Thank you!!!

1 Reply

@Jganz 

=IF(L1="","",M1-L1)