this is my statement
=IF(G7 < 6, G7 * D22) + IF(5 < G7 < 11, G7 * D23) + IF(10 < G7, G7 * D24)
it works if G7 cell value is less then 6 or greater then 10, but if G7 value is from 6 to 10 the result is 0. Cell D23 has value of 15.
What can be wrong?
Thank you
Aucun commentaire:
Enregistrer un commentaire