Need formula help

[danlinksman]

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

 

[Elkar]

Try this:

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

HTH,
Elkar

 

[carlo]

Try this

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

hth

Carlo

 

[carlo]

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

 

[Pete_UK]

Okay, try it this way:

=IF(AND('Start Page'!$E$19>10000,'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