Hi,

I am trying to create a nested if formula for a commision spreadsheet. So far ive got the following formula:

=IF(E11=Data!A11;(L9-O9)*0,02)+(O9*0,2);IF(E11=Data!G11;O11*0,4;IF(E11=Data!G11;O11*0,2))

However, this only returns an error.

The explanation for the formula is various calculations for wage depending on what kind of product is being sold. The products are chosen from a dropdown list (with reference to a data tab, with the following options= "Option 1", "Option 2" and "Option 3"

If "Option 1" = (O11*0,2)
If "Option 2" = (L11-O11)*0,02)+(O11*0,2)
If "Option 3" = (O11*0,4)

Can anyone please help make this formula work in Google Docs?