mardi 16 juin 2020

Microsoft Excel - Grabbing values > 0

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:

enter image description here

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