Excel/Conditional If formula
I am facing a problem. I have a excel spreadsheet which looks as;
BB UK 1
Voice International 1.50
Internet UK 2.00
With 215000 rows.
I would like to know whether I can use a formula to separate the costs incurred to UK and International usage by using a formula were I can separate the costs in different columns to UK and International.Please help.
Thanks in advance.
An if formula will work perfectly and it would look like this.
your first column of data is A
the second column is B
the third column is C
A1 would contain BB
B1 would contain UK
C1 would contain 1
The formula you would put in cell D1 would be
The formula you would put in cell E1 would be
As you can see if column B contains UK then the value from column C is put into column D if its not UK then the formula puts in "", or a blank. If column B contains International then the value from column C is put into column E, if its not then a "" is put in column E.
You can put these formulas into the first two cells of the column as appropriate and then copy them down as far as you would like to.
If I understand the problem, then this should work for you.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here