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.

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.

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

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"danlinksman" escreveu:

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.

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.

What do you want to happen in these cases? At the moment you are only
testing for greater than or equal to 10,000 and returning G15, so would you
like to return some other cell's value if E19 is between 100,000 and
1,000,000? What do you want if E19 is more than 1,000,000?

Pete

"danlinksman" wrote in message
...
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.