Multiple IF statements

[Ashintosh]

Hello,

I am making a spreadsheet for my eBay account and need some help using LibreOffice, but it very similar to Excel.

I have a category box "cell C5" where I will type in Electronics, or Media.
I have tried to write in IF statment but keep getting errors. In another cell I need it to say something like this "=IF (C5="Media";"9%", IF (C5="Electronics";"5%"))" but this comes up with error 508.

I then need another cell which will have a statement saying "=IF (J5="9%";"H1/100*9", IF (J5="5%";"H1/100*5"))". I also need the electronic 5% to only reach a maximum of £10. Cell J5 is the total cost.

These are the formulas I have tried to no avail.

 

[fibonacci1101]

"=IF (C5="Media";"9%", IF (C5="Electronics";"5%"))"

You have to use "," instead of ";"

 

[Ashintosh]

"=IF (C5="Media";"9%", IF (C5="Electronics";"5%"))"

You have to use "," instead of ";"

I got an error: 508