Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 10th 07, 01:15 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2
Default 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   Report Post  
Old 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
Default 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



  #3   Report Post  
Old July 11th 07, 06:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2
Default 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
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- Hide quoted text -


- Show quoted text -





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent Help Required - Conditional Formatting CBD Excel Discussion (Misc queries) 3 May 25th 07 01:22 PM
Conditional Formula help required TomGill Excel Worksheet Functions 3 June 8th 06 01:24 AM
formula required for excel 2002 jmlsav2 Excel Discussion (Misc queries) 2 September 21st 05 10:12 AM
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
excel page breaks - urgent help required Louisa Excel Worksheet Functions 2 February 14th 05 05:03 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017