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,
==IF(AND(G7="X",F7<1400),F7+200,F7)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks