Formula to return numerical, text result?

I need to create a formula that based upon three possible factors, will 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!

=IF(B1="Good","Text",IF(B1="Better",A1*0.3,IF(B1="Best",A1*0.5,"error")))
copy down column
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"burgeon" <[email protected]> wrote in
message news:[email protected]...
>
> I need to create a formula that based upon three possible factors, will
> 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!
>
>
> --
> burgeon
> ------------------------------------------------------------------------
> burgeon's Profile:
> http://www.excelforum.com/member.php...o&userid=20231
> View this thread: http://www.excelforum.com/showthread...hreadid=507256
>

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

Vaya con Dios,
Chuck, CABGx3



"burgeon" wrote:

>
> I need to create a formula that based upon three possible factors, will
> 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!
>
>
> --
> burgeon
> ------------------------------------------------------------------------
> burgeon's Profile: http://www.excelforum.com/member.php...o&userid=20231
> View this thread: http://www.excelforum.com/showthread...hreadid=507256
>
>

Thank you, gracias...

In article <[email protected]>, "Bernard Liengme" <[email protected]> wrote:
>=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)