IF construct in Excel

Question

Can anyone help me perform the following...

example:

      A    B C D

row 1 ODZN 2 3 

row 2 EAXO 3 4

I need a IF then statement which gives this logic...

If A:1 is ODZN, then D1=(B:1)*(C:1)*5 , else if
If A:2 is EAXO, then D1=(B:2)*(C:2)*20 ... and so on with different variables.... every different variable has a different multiplier.......

and I'll copy and drag the formula down a large set of data and eventually into a macro

could anyone help.. and possibly advise me what I need to define as a variable...

The multiplier is set by me manually. The variables will be defined in excel.

Thanks!!

@Michael Downey: Please choose a question title that is more descriptive than "Excel VBA Question". — Jean-François Corbett
– Jean-François Corbett, Commented Jul 4, 2011 at 7:24

Dante May Code · Accepted Answer · 2011-07-01 04:17:07Z

3

I suppose you mean:

for a row, if value in column A is ODZN / EAXO, then value in column D gets a multiplier 5 / 20.

Answer:

=B1*C1*IF(A1="ODZN",5,IF(A1="EAXO",20,0))

and then drag.

You can nest as many IF as you want. (Here I use I an unnecessary 0 to show how IF can be nested, it can be simplified as IF(A1="ODZN",5,20)).

Of course, you can write a function, then it will be like

=B1*C1*func(A1)

However, macros need authentication to run in later versions of Excel. I would recommend the formula solution if the value variation is not that many.

answered Jul 1, 2011 at 4:17

Dante May Code

11.3k9 gold badges52 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

IF construct in Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related