I am having issues with an "if" formula. This is what I need to happen; if I
type 95, 96, 97, 98, 99, or 100 in a specific field I need that same field to
then show the word PLATINUM.

=IF(AND((A194),(A1<101)),"PLATINUM","")

--
Gary''s Student - gsnu200761

If I read the question correctly, Gary's solution won't work ... Jason
wants to enter his numbers in A1 (for example) and have A1 say
'PLATINUM'. You'd need to use VBA to do this ....

i read the reguest the same way as ray. not happening today. gary's answer
would work.....off to the side.... but not IN the cell. I think jason need to
re-think his project.

regards
FSt1

"Ray" wrote:

If I read the question correctly, Gary's solution won't work ... Jason
wants to enter his numbers in A1 (for example) and have A1 say
'PLATINUM'. You'd need to use VBA to do this ....

On Fri, 21 Dec 2007 16:44:02 -0800, JasonTWCWI
wrote:

I am having issues with an "if" formula. This is what I need to happen; if I
type 95, 96, 97, 98, 99, or 100 in a specific field I need that same field to
then show the word PLATINUM.

You can't do it with an IF formula because when you type in a value, you will
erase the IF formula.

You could do it with custom formatting.

e.g. Format/Cells/Number/Custom
Type: [<95]General;[<=100]"Platinum";General


--ron

Wow Ron! Never knew this could be done......VERY Useful.

Rob

"Ron Rosenfeld" wrote in message
...
On Fri, 21 Dec 2007 16:44:02 -0800, JasonTWCWI
wrote:

I am having issues with an "if" formula. This is what I need to happen;
if I
type 95, 96, 97, 98, 99, or 100 in a specific field I need that same field
to
then show the word PLATINUM.

You can't do it with an IF formula because when you type in a value, you
will
erase the IF formula.

You could do it with custom formatting.

e.g. Format/Cells/Number/Custom
Type: [<95]General;[<=100]"Platinum";General


--ron

On Sat, 22 Dec 2007 16:41:18 +1030, "RobN" wrote:

Wow Ron! Never knew this could be done......VERY Useful.

Rob

You're welcome. Glad to help.
--ron