mardi 19 mai 2015

If else if statement in libre office

I am using libre office and I am trying to apply If else if statement but I couldn't do that

I have numbers with multiple conditions
In column "E" I have numbers
I want separate massages for separate numbers

For number-  0.00 = "standard 5,60 Euro charge"
For number-  5,60 = "standard 5,60 Euro charge"
For number-  8,00 = "standard 5,60 Euro charge"
For number- 10,95 = "Standard 14,95 Euro charge" 
For number- 24,95 = "express 29,95 Euro charge"
for number- 30,00 = "Super 45,00 Euro charge"
=IF(E3<="8";"standardpaket 5,6 euro netto" ;elseif(E3="10.95";"DHL Sperrgut 14,95 Euro netto";elseif(E3="24.95";"DHL Express 29,95 Euro netto";else;"Free")))

I have tried with this but not works

I want massages in column "H" anybody can help

Thnks

Aucun commentaire:

Enregistrer un commentaire