Formula to return numerical, text result?

[burgeon]

I need to create a formula that based upon three possible factors, wil
return one of two calculations or a text message.

If cell B="Good", the formula in cell C returns "Text"
If cell B="Better", the formula in cell C returns cell A*.3
If cell B="Best", the formula in cell C returns cell A*.5

Thanks in advance for any tips

 

[Bernard Liengme]

=IF(B1="Good","Text",IF(B1="Better",A1*0.3,IF(B1="Best",A1*0.5,"error")))
copy down column

 

[Guest]

=IF(B1="good","Text",IF(B1="better",A1*0.3,IF(B1="best",A1*0.5,"")))

Vaya con Dios,
Chuck, CABGx3

 

[burgeon]

Thank you, gracias..

 

[Bruce Sinclair]

=IF(B1="Good","Text",IF(B1="Better",A1*0.3,IF(B1="Best",A1*0.5,"error")))
copy down column

After yet another requirement for nested ifs to do something kind of
simple, it occurs to me that XL could really benefit from something like a
case statement.
That would effectively remove the need for nested ifs and make the selection
process far simpler and easier to read and understand.

What do people think ... and is there any chance that xl could get this
added in the near future ?
Or is there something out there already donig this sort of thing ?


Thanks

Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)