Calculate the sum based on the status of a certain cell
Sell N2 dictates whether minimum hours are due to vendor.
If minimum hours are due, N2=Yes, I would like to calculate D8*J8+I8. But only if the value in cell J8 is greater than the value in cell H8. The sum will be shown in cell P8.
If minimum hours are not due, N2=No, I would like to calculate D8*H8+8. Again, the sum would be displayed in cell P8.
Hope this makes sense.
If N2 = "Yes" but J8 is not greater than H8, what result do you want?
Formula:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
What are the desired results in P8 to P10?
Like this?
Please Login or Register to view this content.
But gives same results as the formula you already have, i.e. the additional condition is not changing the result in these cases.
If N2 = "Yes" but J8 is not greater than H8 then I would want the row to calculate D8*H8+I8 instead.
Then this:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks