I have a worksheet that I use for contract variations.
I use a vlookup to populate cells from a drop down list.
The criteria is split up as our cost and direct cost.
I've added a column to show if the cost is direct.
I want to be able to show the calculation in the direct column based on the cell containing "D" and the product of the Quantity *Rate*Factor.
Is there an IF formula that can do this.
I've attached a draft worksheet.
so if there is a D in column E
Column J = blank? and Column K = Qty x Factor x Rate ?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
hmm attached what i think you want?
Thanks humdingaling, that did the trick.
not a problem
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks