How to create an IF/OR statement in Excel?

Question

Hi I need to know how to create an IF/OR statement in Excel.

Basically I want something like this (but this isn't correct)

IF B2 = 1 THEN 10 OR B2 = 2 THEN 20 OR B2 = 3 THEN 30

So if Cell B2 has the value of 1 then I want the number 10 to populate in cell B2 but if Cell B2 has 3 then I want the value of 30 to populate.

Thank you!

Answer 1

it is to complicated to respond to here. pass to Mr.Excel and you will get the respond contained in the boards. First you could upload component of your excel spreadsheet, which you waiting for this reason a great way 2d you could information what you elect clearer in return somebody will placed up the answer to you, particularly in the present day. There are some Template on the Microsoft internet site that ought to create a fact from a database. i assume that what you created. in case you in basic terms had to replace the main modern information for one or all customers on their purchases i could use a pivot table. yet once you elect to create a shopper fact that ought to require some very state-of-the-paintings formulae and set-up, that's merely too complicated for Questions. appropriate answer pass to Mr. Excel, see hyperlink under

Answer 2

Its all in Excel! Just click on Insert/ Function. Then select IF from the choices and it tells you how to do it.

Answer 3

yes