Help With Excel Formula

[joggerjayne]

Can I do this?

I have 3 columns ... A, B, C

In column A, I will insert a figure.

In column B, I will insert various words.

I need an IF,THEN formula for column C, as follows:

If the word in column B is "Referral", then column C needs to be 20% of column A.

If there is any other word in column B, then column C is to stay blank for me to insert my own figure.

Any ideas?

Going out for a bit. Back around 5 ish.

J x

[jim360]

You need to type carefully, but I'd have thought that the formula:

=IF(B1="Referral",0.2*A1,"")

would be as close as you can get. This works in LibreOffice, so probably will work in excel too. There are in the formula above two adjacent speechmarks -- you could insert a space between them, or not, but the output generated is:

50 Referral 10
12 blahbla
10 Referral 2

For example.

[joggerjayne]

Hi, jim

I just got back and tried that formula, and it works.

Thank you very much. Big hug from me ... xxx

JJ

[DTCwordfan]

Awww, JJ, give him a kiss and best answer. I would have done it the same way.