Forum Discussion
I need help to find the correct formula, accounting
Hi I have put my accounting data in to Excel. Different expenses should be placed in different columns. E.g tools, food, fee, etc. Lets say I have 5 different expense categories, but now all expense...
Let's say the data begin in row 2.
In E2: =IF(D2=1,C2,"")
In F2: =IF(D2=2,C2,"")
In G2: =IF(D2=3,C2,"")
In H2: =IF(D2=4,C2,"")
In I2: =IF(D2=5,C2,"")
Select E2:I2, then fill or copy down.