Solved IF greater than less than problem

June 4, 2013 at 10:21:39
Specs: Windows 7
I need to write a formula for the following:

If B12 < 800 = 0
If B12 >800 and <1000 = B12
If B12 >1000 = 1000

Can someone hlep?


See More: IF greater than less than problem

Report •


#1
June 4, 2013 at 11:00:44
✔ Best Answer
What happens if B12 = 800 or B12 = 1000?

In any case, DAGS for Nested IF.

One such hit:

http://www.youtube.com/watch?v=VDXV...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question