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

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

Try this

=if(and('Start Page'!$E$19<=100,000,'Start Page'!$E$19=10,001),G15,0)

hth

Carlo

On Dec 11, 8:52 am, 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

Hehe, you beat me there Elkar :)

although in your formula, 10000,1 would also result in TRUE, which
maybe is not what he wants, so pay attention danlinksman!

cheers Carlo

On Dec 11, 9:05 am, carlo wrote:
Try this

=if(and('Start Page'!$E$19<=100,000,'Start Page'!$E$19=10,001),G15,0)

hth

Carlo

On Dec 11, 8:52 am, 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- Hide quoted text -

- Show quoted text -

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