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