Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible
A lawyer would like a conditional formula for both the Vendors Receive
and Purchaser Receive columns that says something like if the difference between the Estimated Purchase Price less the Holdback is less than the Actual Purchase Price than Vendor Receives and Purchaser Receives but if the Actual Purchase Price is more than the Estimate Purchase Price the Vendors Receive and the Purchaser Receives (and I have no clue what I am talking about but hope someone with lots of Excel experience understands and can set out the exact conditional formula for me). B C D F G H I J Estimated Purchase Price Holdback EPP less holdback actual Purchase price F - B Vendors Receive Purchaser Receives shortfall in Holdback 2,350,000 100,000 2,345,000 -5,000 95,000 5,000 please e-mail me with response as well to thanks - Bonnie McKinnon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible
Bonnie,
Can you give some examples? Include the columns the data is in, and the expected results. That example doesn't seem to make sense. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "blue" wrote in message ups.com... A lawyer would like a conditional formula for both the Vendors Receive and Purchaser Receive columns that says something like if the difference between the Estimated Purchase Price less the Holdback is less than the Actual Purchase Price than Vendor Receives and Purchaser Receives but if the Actual Purchase Price is more than the Estimate Purchase Price the Vendors Receive and the Purchaser Receives (and I have no clue what I am talking about but hope someone with lots of Excel experience understands and can set out the exact conditional formula for me). B C D F G H I J Estimated Purchase Price Holdback EPP less holdback actual Purchase price F - B Vendors Receive Purchaser Receives shortfall in Holdback 2,350,000 100,000 2,345,000 -5,000 95,000 5,000 please e-mail me with response as well to thanks - Bonnie McKinnon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required - Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formula help required | Excel Worksheet Functions | |||
formula required for excel 2002 | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
excel page breaks - urgent help required | Excel Worksheet Functions |