Remember Me?

#1
July 10th 07, 01:15 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2
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
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
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
July 10th 07, 09:05 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 10,594
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
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
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

#3
July 11th 07, 06:08 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible

I know I wasn't very clear because I was not sure what the lawyer
wanted exactly. Anyway, I got a response and an attachment from the
Excel list - from Bob Gately - which may do the trick and I forwarded
it on to the lawyer to check it out when she gets time as she went
with another idea because I did not immediately have the Excel answer
she needed. She will look at the Excel list response from Bob Gately
when things settle down so I may be getting back to this forum and my
Excel list if it was not helpful to her.

If you wish I can send you the Holdback 2007.xls document that Bob
Gately sent me but how should I do that?

Thanks for responding to this Excel request. - Bonnie McKinnon

On Jul 10, 1:05 am, "Bob Phillips" wrote:
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
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
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- Hide quoted text -

- Show quoted text -

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post CBD Excel Discussion (Misc queries) 3 May 25th 07 01:22 PM TomGill Excel Worksheet Functions 3 June 8th 06 01:24 AM jmlsav2 Excel Discussion (Misc queries) 2 September 21st 05 10:12 AM Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM Louisa Excel Worksheet Functions 2 February 14th 05 05:03 PM

All times are GMT +1. The time now is 08:31 AM.