Hi Paul:

Thank you for all your help.....I used RagDyeR's formula and it works....I
will also keep your's of file for use in the future...

You have been so kind and helpful and I appreciate it!
--
jeannie v


"PCLIVE" wrote:

Assuming your 3 (variable) will be in A1:

=IF(B1317,A1,0)

Adjust "A1" to the cell containing 3 or your variable. I'm not sure if that
is what you were saying. If not, please elaborate.

Regards,
Paul


--

"jeannie v" wrote in message
...
Hi Paul:

OK...now if the 3 is variable, how would I replace the 3 so that whatever
the result is it will be returned?

Thank you for all your help,
--
jeannie v


"PCLIVE" wrote:

Maybe this is what you want:

=IF(B1317,3,0)

HTH,
Paul

--

"jeannie v" wrote in message
...
Hi Experts:

I've poured over the other questions and responses on this site and
either
missed my situation or it's not there...I need help with what should be
so
simple...

Example: B13 is 20...I want C13 to give me the result of 3 of B13 is
greater than 17....I then need the formula to say...If B13 is not
greater
than 17, enter 0.

This formula that I've started returns the result of 1 not 3...I then
need
to expand the formula to enter zero if B13 is not greater than 17. The
result would be returned in C13.

=SUM($B1317)

I know this is really simple, so be kind....my brain is fried....

Thank you so much for all your expertise.....
--
jeannie v