Multiply if or percentage if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Juulia - 25 Jan 2007 11:40 GMT

Hello

I am not able to do this formula without help.

I need a formula that checks if the cell O15 has the letter Y. If yes, it
should give as a result 25% of the value in cell F15 (or multiply F15 by
25/100). If no, it should give as a results the value in cell F15 (100%).

Excel help gives the model IF(logical_test,value_if_true,value_if_false) but
I don't manage putting a formula in the plae of value_if_true or =F15 in the
place of value_if_false. And then I've tried as logical_test O15=Y or with
asterisks O15=*Y* but nothing works.

Thanks!

Juulia

Reply to this Message

Roger Govier - 25 Jan 2007 11:51 GMT

Hi Juulia

You need double quotes around the Y
=IF(O15="Y",F15*25%,F15)

Signature

Regards

Roger Govier

> Hello
>
[quoted text clipped - 14 lines]
>
> Juulia

Reply to this Message

Juulia - 25 Jan 2007 12:04 GMT

Many thanks!

It worked but strangely only after I replaced the commas with semicolons:
=IF(O15="Y";F15*25%;F15)

I use a different if formula succesfully where I have asterisks with the
letter: =SUMIF(O13:O100;"=*A*";F13:F100) I don't know if there is any logic
in there.

> Hi Juulia
>
[quoted text clipped - 17 lines]
>>
>> Juulia

Reply to this Message

Roger Govier - 25 Jan 2007 12:26 GMT

Hi Juulia

The difference between the commas and semicolons is due to differences
in the Regional separator used for the version in your country. The UK
and the US use comma as the separator but other countries may use
semicolon.

> =SUMIF(O13:O100;"=*A*";F13:F100)

In this case, you were telling Sumif that you wanted anything which has
an A in the field in column O

So it would match with Antelope, Canada, SA100, BA500 etc.

Signature

Regards

Roger Govier

> Many thanks!
>
[quoted text clipped - 28 lines]
>>>
>>> Juulia

Reply to this Message

Bob Phillips - 25 Jan 2007 12:27 GMT

It just means that your function separator is semi-colon, Roger's is comma.
That is common with continental systems.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Many thanks!
>
[quoted text clipped - 27 lines]
>>>
>>> Juulia

Reply to this Message

Juulia - 25 Jan 2007 17:52 GMT

Thanks for all your replies.

Sorry to bother you again but I need the same thing but a bit more
developed. A formula which checks up, say, cell A5 and

if there is an A, gives 30% of the value in cell A7
if there is a B, gives 70% of the value in cell A7
if there is a C, gives the value in cell A7 (100%)

So how do you use multiple conditions that give multiple results?

Thanks!

Reply to this Message

Roger Govier - 25 Jan 2007 18:05 GMT

Hi Juulia

Try

=IF(O15="A";F15*30%;IF(O15="B";F15*70%;IF(O15="C";F15;"")))

Alternatively, if result B is always the reciprocal of result A in terms
of percentage, you could enter your 30% in a cell, say O16 and use

=IF(O15="A";F15*A16;IF(O15="B";F15*(1-O16);IF(O15="C";F15;"")))

Signature

Regards

Roger Govier

> Thanks for all your replies.
>
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Juulia - 25 Jan 2007 18:38 GMT

Works wonders! Thanks!

Reply to this Message

Rate this thread: