Help Conditianal Formula Help

[Guest]

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

 

[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

In some cell 'c'

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


--ron

 

[Guest]

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

 

[Ron Rosenfeld]

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

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