Please Help

J

JasonTWCWI

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.
 
R

Ray

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 ....
 
F

FSt1

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
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
R

RobN

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

Rob

Ron Rosenfeld said:
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.
Click to expand...

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
Click to expand...
 
Top