Try this:

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

HTH,
Elkar


"danlinksman" wrote:

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