Is there any way using Microsoft excel to do an equation that does something like this:
IF(Condition, If true, If false) <-- Just in case, this is how an if statement is formatted
IF(a cell in a range has a value other than zero, put that/those value(s) here, do nothing)
For example:
IF(B1:B13 is something other than 0, grab that value, do nothing)
Based on the table above and the "equation" I am trying to figure out, it would return 12 and 17, 15.
Let me know if I need to clarify anything.

Aucun commentaire:
Enregistrer un commentaire