Hi All, I hate IF statements I know what I want from them can just never work it out!!!!!
So in a cell I have a description, say "FOOD" then another cell with amount say £2, then in another cell I want it to be looking and if it sees "FOOD" entered, it takes the amount £2 and adds it to a running balance.
Cell A1 = Food
Cell B1 = £2
Cell H1 = (looks and if Food) adds £2 to cell
Can it be done?
Thanks![]()
Bookmarks