Formula help

  • Thread starter Thread starter danlinksman
  • Start date Start date
D

danlinksman

Currently I have an "if" formula that looks a value on another sheet which
looks like this =IF('Start Page'!$E$19>10000,G15,0). My problem is that when
10,000 is put in it does not caluculate correctly because it is not > but =
to. How do I modify the formula to include = to.
 
try
=IF('Start Page'!$E$19>=10000,G15,0)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"danlinksman" escreveu:
 
This works, however I forgot to metnion one other part of my formula. I also
need it to be able state the following

If less than or equal to 100,000 but not less than 10,000
and
If less than or equal to 1,000,000 but nott less than 100,000

Any suggestions,

Thanks

Dan
 
What do you want to happen in these cases? At the moment you are only
testing for greater than or equal to 10,000 and returning G15, so would you
like to return some other cell's value if E19 is between 100,000 and
1,000,000? What do you want if E19 is more than 1,000,000?

Pete
 
Back
Top