Function help

M

Melanie

I want to have G3 as a cell where we enter a number and need a formula to do
the following in H3:

If G3 is between 50,000 and 100,000 then leave H3 blank

If G3 is less than 50,000 or greater than 100,000, then H3 would say "wrong
spreadsheet"

Can someone help me? I can get one half or the other to work, not both.
Thanks.
 
C

CyberTaz

It isn't clear whether you want the 50000 & 100000 range to be inclusive of
those values, but if not here's one option. In cell H3 enter the formula:
=IF(OR(G3<50000,G3>100000),"wrong spreadsheet","")
 
Top