Multiply if or percentage if

[Juulia]

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

 

[Roger Govier]

Hi Juulia

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

 

[Juulia]

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.

 

[Roger Govier]

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.

 

[Bob Phillips]

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Juulia]

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!

 

[Roger Govier]

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;"")))

 

[Juulia]

Works wonders! Thanks!