Formula please

[Mel]

Hi, hope someone can help. I am trying to get a value in dollars in one cell
dependant on another cell being one of two letters. If a particular letter
appears then the cell will give the result of a third cell multiplied by 9%,
if it is a different letter it will give 9% of another cell.

eg

the result will be in K30
if K15 is "T" then k30 will be p20*9%, but
if K15 is "P" then K30 will be P21*9%

Thank you if anyone can help.

Mel

[JE McGimpsey]

One way:

=IF(K15="T", P20*9%, IF(K15="P",P21*9%,"Not T or P"))

In article <eM1rjLTaGHA.3328@TK2MSFTNGP02.phx.gbl>,
"Mel" <mgsg@bigpond.net.au> wrote:

> Hi, hope someone can help. I am trying to get a value in dollars in one cell
> dependant on another cell being one of two letters. If a particular letter
> appears then the cell will give the result of a third cell multiplied by 9%,
> if it is a different letter it will give 9% of another cell.
>
> eg
>
> the result will be in K30
> if K15 is "T" then k30 will be p20*9%, but
> if K15 is "P" then K30 will be P21*9%
>
> Thank you if anyone can help.
>
> Mel

[David McRitchie]

Hi Mel,
K30: =IF(K15="T",P20*.09,IF(K15="P",P21*.09,"")

You did not say what the value would be otherwise so I used
a null string. Null string will be ignored in SUM but would result in
an error if used as an addend in a formula. If used in another
formula you might want to use 0 (zero)..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mel" <mgsg@bigpond.net.au> wrote in message news:eM1rjLTaGHA.3328@TK2MSFTNGP02.phx.gbl...
> Hi, hope someone can help. I am trying to get a value in dollars in one cell
> dependant on another cell being one of two letters. If a particular letter
> appears then the cell will give the result of a third cell multiplied by 9%,
> if it is a different letter it will give 9% of another cell.
>
> eg
>
> the result will be in K30
> if K15 is "T" then k30 will be p20*9%, but
> if K15 is "P" then K30 will be P21*9%
>
> Thank you if anyone can help.
>
> Mel
>
>

[Pete_UK]

Enter this in cell K30:

=IF(K15="T",P20*0.09,IF(K15="P",P21*0.09,0))

You don't say what you want to happen if K15 is neither of these values
- this formula returns 0 in this case.

Hope this helps.

Pete

[David McRitchie]

was missing the close paren at the end, but then you already had another answer anyway.
K30: =IF(K15="T",P20*.09,IF(K15="P",P21*.09,""))

[Mel]

Thank You, that worked without the last bracketed bit, thank you so much.

Mel

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-4900B2.07345526042006@msnews.microsoft.com...
> One way:
>
> =IF(K15="T", P20*9%, IF(K15="P",P21*9%,"Not T or P"))
>
> In article <eM1rjLTaGHA.3328@TK2MSFTNGP02.phx.gbl>,
> "Mel" <mgsg@bigpond.net.au> wrote:
>
>> Hi, hope someone can help. I am trying to get a value in dollars in one
>> cell
>> dependant on another cell being one of two letters. If a particular
>> letter
>> appears then the cell will give the result of a third cell multiplied by
>> 9%,
>> if it is a different letter it will give 9% of another cell.
>>
>> eg
>>
>> the result will be in K30
>> if K15 is "T" then k30 will be p20*9%, but
>> if K15 is "P" then K30 will be P21*9%
>>
>> Thank you if anyone can help.
>>
>> Mel

[Mel]

sorry, I meant last bit i.e. I put a zero in after the 9% and it works, well
I hope it does, as I am so tired, I've tried it a couple of times and think
this will do it. Thanks again
Mel

=IF(K15="T", P20*9%, IF(K15="P",P21*9%,0))
"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-4900B2.07345526042006@msnews.microsoft.com...
> One way:
>
> =IF(K15="T", P20*9%, IF(K15="P",P21*9%,"Not T or P"))
>
> In article <eM1rjLTaGHA.3328@TK2MSFTNGP02.phx.gbl>,
> "Mel" <mgsg@bigpond.net.au> wrote:
>
>> Hi, hope someone can help. I am trying to get a value in dollars in one
>> cell
>> dependant on another cell being one of two letters. If a particular
>> letter
>> appears then the cell will give the result of a third cell multiplied by
>> 9%,
>> if it is a different letter it will give 9% of another cell.
>>
>> eg
>>
>> the result will be in K30
>> if K15 is "T" then k30 will be p20*9%, but
>> if K15 is "P" then K30 will be P21*9%
>>
>> Thank you if anyone can help.
>>
>> Mel

[Mel]

Thank you everyone , and good night for now :-)
Mel

"Pete_UK" <pashurst@auditel.net> wrote in message
news:1146058806.415721.255690@i39g2000cwa.googlegroups.com...
> Enter this in cell K30:
>
> =IF(K15="T",P20*0.09,IF(K15="P",P21*0.09,0))
>
> You don't say what you want to happen if K15 is neither of these values
> - this formula returns 0 in this case.
>
> Hope this helps.
>
> Pete
>

[Pete_UK]

It's mid-afternoon here, but goodnight wherever you are - thanks for
feeding back.

Pete