Help Conditianal Formula Help

K

Kroeger

Hi I'm having a hard time creating a conditional formula if the condition
depends on a word instead of a number. example is c=1.25 if value=low, c=1 if
value is average, c=.75 if value is high. sorry for the inconvenience i know
i should know this but i cant figure it out. Thanks for the help
 
R

Ron Rosenfeld

Hi I'm having a hard time creating a conditional formula if the condition
depends on a word instead of a number. example is c=1.25 if value=low, c=1 if
value is average, c=.75 if value is high. sorry for the inconvenience i know
i should know this but i cant figure it out. Thanks for the help
Click to expand...

In some cell 'c'

=IF(value="low",1.25,IF(value="average",1,IF(value="high",0.75,"no value")))


--ron
 
R

Ron Rosenfeld

Thanks for the reply but how do i link them to another cell
Click to expand...

What is "them"?

If "them" is what you have specified as "value" (high, low, average),
substitute the cell reference for "value", or name that cell: value. That cell
should then contain the string.

If "them" refers to something else, you will need to be more specific.

In your original post, you also did not define "c" although you used it several
times. I assumed that "c" represented the cell in which you wrote the formula.


--ron
 
Top