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 -