Writing a Formula with if condition and multiplying few cells but one of the cell with condition

[RapchikM]

Hello

How i can write a formula i a cell with if condition

Want multiplication in cell N12 = J12 * K12 * M12 * L12
but there is a condition with cell L12

Condition is as follows
By default i want value in cell L12 = 1 when cell L12 is Empty or Blank and to display cell as blank
Else if L12 is Non Empty L12 should take value as Whatever Entered in Cell L12

How should i write as forumla in cell
N12 = J12 * K12 * M12 * =if(L12="", 1, L12)


Any methods i can achieve this
RapchikM

 

[Joe4]

You pretty much already have it:

= J12 * K12 * M12 * if(L12="", 1, L12)

 

[RapchikM]

Thank you Sir,
Hope i had not incorporated = sign before IF

RapchikM

 

[Joe4]

You are welcome.

In a formula cell, you will only ever have the beginning equal sign signifying the start of the formula in the first characters.
If you "imbed" other formulas within that formula, you would drop off the leading "=".

 

[RapchikM]

Thank you very much for clarifications.

Very much appreciated

RapchikM