Software

Ask something
Question Locked

Formulas in Excel

0 helpful
2 replies

by rjae 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

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

2 replies

by nexs

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
deciphered
=IF(all the following are true(A2 is greater than 2, A2 is less than 20), show the value in A2 if "IF" is true, show blank if "IF" is false)

::edited for formatting and speling::

This discussion is closed to new replies.