vendredi 15 février 2019

Can I use an IF statement to multiply one number by a list/range of number in Excel?

I'm using excel and I want to use an IF statement to check if a certain number (x) multiplied by any integer would give me a different certain number (72). If it does I'd like the cell to return (72), if not then I'd like for the cell to be blank.

In my head, such a formula would look something like this:

=IF(X*(list_of_integers) = 72, 72, ="")

Is this possible? If it is how could I do it?

Aucun commentaire:

Enregistrer un commentaire