I have a tally sheet that I keep monthly and until recently has worked to perfection. I was thrown a curveball this month and need to change the way a calculation is done but can not seem to figure it out.
If the value in column "F" is less than 1400 and the value in column "g" equals "X" I need 200 added to column "F". I have tried =IF(G7=X,+F7+200,F7) but the "X" errors.
Any help would be welcomed.
Bookmarks