Formula help
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.
|