How to insert an ELSE IF in as google sheets, as I can't seem to use 2 IF Statements in the sam-CodePudding

I am trying to make a formula that changes depending on the cell containing the sex value however I can't seem to correct it. I am new to spreadsheets so I may be missing a big and obvious step.

=IF(C3="Female" (655.1 (9.563C6) (1.850C7)-(4.676C4)) ELSE IF (C3="Male" (66.5 (13.75C6) (5.003C7)-(6.75C4))))

CodePudding user response：

So, without an example, this is how I would edit / correct your existing formula:

=IF(C3="Female",(655.1 (9.563 * C6) (1.850 * C7)-(4.676 * C4)),IF(C3="Male",(66.5 (13.75 * C6) (5.003 * C7)-(6.75 * C4),"error")))

CodePudding user response：

try:

=IF(C3="Female"; 
 (655.1 (9.563*C6) (1.850*C7)-(4.676*C4)); 
 (66.5 (13.75*C6) (5.003*C7)-(6.75*C4))))