I will try to explain it as clear as I can. This is what i need the formula to work out:
If (F1) is between ($0 and $100,000) and (D1) is equal to or larger than (E1) then = yes (yes in big green letters, else 'no' in big red letters)
the D1, E1, and F1 cells will have dollar amounts in them.
What i also need if for the range to change in incriments as well:
0-100000,100000-150000,150000-300000,300000-550000,550000-900000,900000-1500000
Any help will be much appreciated!
2007-09-06
18:44:34
·
3 answers
·
asked by
chickenbumflaps
1