If and Function
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.
If you are trying to increment the same cell in F as that which you compared to, VBA will be needed.
What about this,
Do you have any other ideas that might work?
I have attached a sample....
Chippy!!!! That worked great! Thanks
Glad to hear it - thanks for the feedback
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1