If and then

Question

Hello Everybody, I would like to do the following and I cannot get it right with IF and THEN.

In Cell H3 I would like to do the following;

IF L1 is larger than M1 add 10, then subtract F6 from M1 and add the 10

I would really appreciate your help.

Kind Regards,

Pierre (South Africa)

lorenzo · Answer

Hello&nbsp;peers650&nbsp;&nbsp;IF L1 is larger than M1 add 10, then subtract F6 from M1 and add the 10#1&nbsp;add 10 to what (which cell)?#2&nbsp;IF L1 is not larger than M1, what should happen?

peers650 · Answer

LorenzoHi L z, Thank you for the response, will it help if&nbsp; send you the sheet with comments?&nbsp;Kind Regards,Pierre

lorenzo · Answer

peers650&nbsp;will it help if&nbsp; send you the sheet with comments? Sure

sandeepmarwal · Answer

Could you please share the workbook you are working on?

Forum Discussion

If and then

Share

Resources