Okay, try it this way:

=IF(AND('Start Page'!$E$1910000,'Start Page'!$E$19<=100000),G15,0)

This will give you the value of cell G15 if E19 is between the values,
otherwise it will return zero if it is outside the values.

Hope this helps.

Pete


"danlinksman" wrote in message
...
Currently I have an "if" formula that looks a value on another sheet which
looks like this =IF('Start Page'!$E$19<100000,G15,0). My problem is that
when
100,000 is put in it does not caluculate correctly because it is not < but
=
to.
Answer

=IF('Start Page'!$E$19<=100,000,G15,0)

The question above was answered, however I failed to look at other
factors.

I also need the formula to read but not less than 10,001