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