Formulas in Excel

By Rjae ·

How would i go about creating a fomula in excel that can will return a value if it is not found in a datarange??

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

that would be an "if" formula w/ "and" formula

by NexS In reply to Formulas in Excel

whats the logic you want it to follow? 'pseudo code' if you like.
should be something like
=IF(AND(A2>2, A2<20), A2, "")
a2 is said to be your variable cell
=IF(<i>all the following are true</i>(A2 <i>is greater than</i> 2, A2 <i>is less than</i> 20), <i>show the value in</i> A2 <i>if "IF" is true</i>, <i>show blank if "IF" is false</i&gt

::edited for formatting and speling::

Related Discussions

Related Forums