Hello I am wondering if anyone can help with an if statement, at present I am using the following:
In cell M8 this is my formula =IF(L8<=J8,100%) however I would like to expand this to say if cell K8 has a number then leave cell M8 blank.
Is there a way to do this?
Thanking in advance.
In cell M8 this is my formula =IF(L8<=J8,100%) however I would like to expand this to say if cell K8 has a number then leave cell M8 blank.
Is there a way to do this?
Thanking in advance.