Need formula help

  • Thread starter Thread starter danlinksman
  • Start date Start date
D

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
 
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
 
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
 
Back
Top