This works, however I forgot to metnion one other part of my formula. I also
need it to be able state the following

If less than or equal to 100,000 but not less than 10,000
and
If less than or equal to 1,000,000 but nott less than 100,000

Any suggestions,

Thanks

Dan

"Pete_UK" wrote:

Try this:

=IF('Start Page'!$E$19=10000,G15,0)

Hope this helps.

Pete

On Dec 10, 8:07 pm, danlinksman
wrote:
Currently I have an "if" formula that looks a value on another sheet which
looks like this =IF('Start Page'!$E$1910000,G15,0). My problem is that when
10,000 is put in it does not caluculate correctly because it is not but =
to. How do I modify the formula to include = to.