#### Reference 2

```How do I have a cell look at another cell and make a calculation. For example:

A               B              C
(197)	3500 	500

If column A is less than B then have the calculation of the amount of (C) it
would take to bring it to positive standing. The answer should be 4000. That
is (8) lots of 500 to make the amount 3803. That is C times (8) minus 197. If
(A) was 3501 then I would have a return value of 0. I would not need to
replenish.
```
 0
Utf
2/19/2010 7:13:01 PM
excel.misc 78881 articles. 5 followers.

3 Replies
868 Views

Similar Articles

[PageSpeed] 9

```Assuming your numbers are in cells A1 B1 and C1 then put this formula in cell
D1:

=IF(A1<B1,(ROUNDUP((B1-A1)/C1,0))*C1,0)

Tom

"Jackie Morin" wrote:

> How do I have a cell look at another cell and make a calculation. For example:
>
> A               B              C
> (197)	3500 	500
>
> If column A is less than B then have the calculation of the amount of (C) it
> would take to bring it to positive standing. The answer should be 4000. That
> is (8) lots of 500 to make the amount 3803. That is C times (8) minus 197. If
> (A) was 3501 then I would have a return value of 0. I would not need to
> replenish.
```
 0
Utf
2/19/2010 7:42:01 PM
```Not sure I really understand the problem but does this help:
=IF(A1<B1,CEILING((B1-A1),500),0)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jackie Morin" <JackieMorin@discussions.microsoft.com> wrote in message
news:879D28AF-CB8C-41B6-9D9D-C19E6A416D9F@microsoft.com...
> How do I have a cell look at another cell and make a calculation. For
> example:
>
> A               B              C
> (197) 3500 500
>
> If column A is less than B then have the calculation of the amount of (C)
> it
> would take to bring it to positive standing. The answer should be 4000.
> That
> is (8) lots of 500 to make the amount 3803. That is C times (8) minus 197.
> If
> (A) was 3501 then I would have a return value of 0. I would not need to
> replenish.

```
 0
Bernard
2/19/2010 7:55:32 PM
```That works perfectly. Thanks so much for your help.

"tompl" wrote:

> Assuming your numbers are in cells A1 B1 and C1 then put this formula in cell
> D1:
>
> =IF(A1<B1,(ROUNDUP((B1-A1)/C1,0))*C1,0)
>
> Tom
>
> "Jackie Morin" wrote:
>
> > How do I have a cell look at another cell and make a calculation. For example:
> >
> > A               B              C
> > (197)	3500 	500
> >
> > If column A is less than B then have the calculation of the amount of (C) it
> > would take to bring it to positive standing. The answer should be 4000. That
> > is (8) lots of 500 to make the amount 3803. That is C times (8) minus 197. If
> > (A) was 3501 then I would have a return value of 0. I would not need to
> > replenish.
```
 0
Utf
2/19/2010 8:43:01 PM

Similar Artilces:

Outlook Web Access #2
I have Exchange 5.5 SP4 and Outlook Web Access installed on the Member Windows NT 4.0 Server. If the regular domain user logs in to Outlook Web Access he can see a list of mail messages but when he opens any of them they look like empty, but actually they are not. If user the member of Administrators Group logs in to the Outlook Web Access he is fine. What should I change? ...

Compare entries in 2 worksheets and list what does not match
Good Day All; I have 2 Excell works sheets with approx 14000 rows each. What I would like to do is compare both lists and get a 3rd list that shows what entries do not match. Is there a simple way to do ythis in Excel Thanks All Chomp Assuming A1 should equal A1 in the other sheet... =IF(Sheet1!A1=Sheet2!A1,"",Sheet!A1&" does not match "&Sheet2!A1) Auto-Filter for non-blanks. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "The Chomp" wrote: > Good Day All; > > I have 2 ...

Need Syntax for "AND" to Evaluate 2 Cells
I need to evaluate 2 cells while inside an "Private Sub Worksheet_SelectionChange(ByVal Target As Range)". I thought AND would work but I cannot get it to work; I receive a syntax error on the AND(Range... line. Can someone please provide me the proper syntax to evaluate the 2 cells? Here's my code... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveSheet.Name = "Sheet1" Then And(Range("I3") <> "", Range("K4") = "") Then Range("K4") = Range("K3") End...

Column Reference to External Source As a Variable
Can anyone help me convert the column referenced in the formula below into a variable that the user can define? More specifically, I have several columns that I need to read from an external workbook (Short_Billy.xls). Each column to the right of column C represents an additional day out in a 14 day projection from today (whose data is held in column C). In cell I5 of my active workbook (Inventory.xls), I would like the user to be able to enter a value representing the number of days out they would like to see the projection for (0=today=Column C, 1=Tomorrow=Column D, etc.). In cell I6, I...

How to share same email a/c on 2 pc
I have linked 2 pc via Windows Small Office network. How to let these 2 pc share the same email a/c in Microsoft Outlook. Plse provide solution in detailed steps as I am a novice. Operating syste=xp outlook version 2003 Thanks "Christine" <centrol@singnet.com.sg> wrote in message news:hop8fj\$7la\$1@reader01.singnet.com.sg... > I have linked 2 pc via Windows Small Office network. > > How to let these 2 pc share the same email a/c in Microsoft Outlook. > > Plse provide solution in detailed steps as I am a novice. > > Operating sys...

Scribe Migrate
I am planning to do a reinstall on our CRM server and have purchased Scribe (didn't come in till JUST now), and was planning to do this over the weekend. I have a test environment and want to try it here before I do this on our production. However this isn't as simple as I thought. I know, I know, read the manual, etc, etc etc. But its near critical that I get this production reinstalled, and I'd rather not work straight through a weekend just to learn this thing. Anways, can anyone give me the basic overview of this? Does this take hours just to create the migration setup? For s...

testing (OT) 2
This is a multi-part message in MIME format. ------=_NextPart_000_004E_01C8B5B7.029A2C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I put this post on using the google group version, now using the = Microsoft newsgroup server. I'm trying to pin down what works and what = doesn't and why this specific sign in ID doesn't work on google groups = OR on the news server I use in Outlook Express. But another ID I have = does. I'm posting this using the Microsoft newsgroup server, which is = something else, and should work....

JPG Files #2
Just installed Outlook 2003. Can no longer view jpg files...either those sent to me or ones I try and attach??? Have cleaned out my temp internet files...hELPPPPPPPPPPPPPPPPPPPPP Thx Make sure you have a default program set for opening jpg-files. Rightclick the file from within Windows Explorer nd choose Open With... and make sure you select to always open that file with the selected program You probably had set Microsoft Photo Handler as thedefault program which has been replaced by Picture Manager. -- Roady [MVP] www.howto-outlook.com Tips of the month: -Creating Signatures -Cre...

Cannot close opportunities #2
I upgraded from CRM 3.0 to 4.0 We encountered issues with SQRSS - I had to uninstall and reinstall SQRSS. I am now encoutering issues when closing a new opportunity it error out throwing an Exception of type "System.web.HttpUnhandledException' Full Stack: [NullReferenceException: Object reference not set to an instance of an object.] at Microsoft.crm.dialogs.CloseOppPage.ConfigureForm(_ at Microsoft.crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e) at system.web.UI.Control.PreRenderRecursiveInernal() at System.web.UI.Page.ProcessRequestMain(Boolean includesStagesBefore A...

New entries do not appear in address book contents list. Thought it might be a space problem, but have deleted all extraneous data (i.e. deleted items. However, when I try to re-enter the contact, Outlook asks if I wish to replace the earlier entry for the same contact. Any ideas? Explain more accurately what you mean. Where are entries not appearing that you expect them to? Are you selecting the correct Contacts Folder from the "Show names from..." dropdown? -- Russ Valentine [MVP-Outlook] "Lulu" <anonymous@discussions.microsoft.com> wrote in message news:88020...

Why does 62 KB translate into 4.2 MB in Publisher?
When I added a 62 KB jpeg to my page, the overall file size jumped from ~275 KB to 4.2 MB. What gives? Let me guess - Publisher 2000? -- JoAnn Paules MVP Microsoft [Publisher] "Publisher induced baldness" <Publisher induced baldness@discussions.microsoft.com> wrote in message news:9ED85165-A29E-44AA-AFE6-4F5A5D518991@microsoft.com... > When I added a 62 KB jpeg to my page, the overall file size jumped from > ~275 > KB to 4.2 MB. What gives? Publisher 2000 doesn't support compression. PUB2000: File Size Increases Unexpectedly When You Insert Picture ...

Green triangles #2
thanks for such a speedy response, teh placement of 1 in cell an edit,paste special, multiply works, but why? the value function doesn't work, as the green triangle seems to rende the contents of the cell as neither number or text. strange. once again thanks : -- Stevethedo ----------------------------------------------------------------------- Stevethedoc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=27800 Happy to help. Thanks for the feedback. As to why one works and not the ot...

After 12.2.4 update, cannot open some Word docs with Open passwords
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks Basically, "you can't". Sorry, the other passwords are crackable, but "Password to Open" is effectively the encryption key. The entire file is encrypted, and unless you have the correct password, you can't get it open. However, are you sure you are not attempting to open files that were password-=protected on the PC? ...

Why is Excel changing the last 2 digits of a 17 digit num to 00.
When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to 00 when I leave the cell. Format - Cell does not have a setting to stop this 'feature'. How do I make Excel recongize the large number? On Thu, 28 Jul 2005 19:09:01 -0700, "Allie" <Allie@discussions.microsoft.com> wrote: >When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to >00 when I leave the cell. Format - Cell does not have a setting to stop this >'feature'. Excel Specifications and Limits: Calculation specifications Feature Maximu...

Purchase Order 2.0.0127
Am I the only one having issues with the upgrade? 1) I create a purchase order 2) I click on add item 3) I type in the supplier ILC, and nothing comes up (ONLY on some items)! 4) I click on all items, and find the item, and add it! 5) When I click on OK the item is added to the purchase order, along with the supplier ILC! OR When I click on all items, even though the item may be in the database, I can't find it to add to the PO, unless I close out the PO and re-open it??? This started happening only since I upgraded the the 2.0.0127! -- Thank You Vince :) -- Thank You Vince :) Yes...

Integrating Great Plains 8.0 and CRM 1.2 and Windows Small Busines
Integrating Great Plains 8.0 and CRM 1.2 I run a Windows Small Business Server 2003 Premium box along with a Windows Server 2003 Standard box used for my Great Plains 8.0 and SQL 2000. I’m considering introducing CRM 1.2 Professional into the mix. From a hardware stand point I know I’m fine all around. I’ve been researching how I should configure CRM and am a bit confused. The info I’ve found in KB887153 states “When you install Microsoft Business Solutions CRM Integrations for Great Plains 7.0, 7.5, or 8.0, Microsoft BizTalk Server is also installed. However, BizTalk Server 2000 and B...

SK 40175 Tuff-1 1/2-Inch Drive 15-Inch Reversible Ratchet
Price:\$90.24 Image: http://thediscounfinder.info/image.php?id=B0009U5RRM Best deal: http://thediscounfinder.info/index.php?id=B0009U5RRM Item #: SKT40175. Features & Benefits:Tuff 1(r) Ratchets 72 tooth head design delivers a short 5" stroke for use in tight areas.17 teeth engage when torque is applied to provide a strong grip without slippage.Thumb falls naturally into position, giving instant control with one hand.Easy to reverse, 4 point cap.SuperKrome plating for long tool life and maximum corrosion resistance.Description: 15" Reversible Tuff Customers also search for:...

RMS 2.0 matrix dimensions are annoying, but help is available
For reasons I don't understand, MS saw fit in RMS 2.0 to use dimensions data for matrix components that is far less accessible to users than Sub Descriptions are. For instance, I can't edit assign a dimension value to an existing item I have added to a matrix. I can't see a reason for using Dimensions with limitations like this as using Sub Descs. to describe matrix "dimensions" worked fine previously. Does anyone know why MS did this? It's annoying! Digital Retail Solutions (DRS) has a product called Power Ops (Build 2.2.0003). It's help file mentions (se...

Keyboard Shortcut #2
Is there a keyboard short cut or quick way to switch between tabs or worksheets in an Excel workbook? Thanks Steve Switch tab: Ctrl + PageUp / PageDown Switch workbook: Ctrl + Tab / Shift + Ctrl + Tab (backward) HTH "Steve Cohen" <sacohen@bellsouth.net> �b�l�� news:Gjohb.33943\$9a7.17809@bignews6.bellsouth.net �����g... > Is there a keyboard short cut or quick way to switch between tabs or > worksheets in an Excel workbook? > > Thanks > > Steve > > Here are two links that provide info on more keyboard shortcuts. http://www.cpearson.com/excel/...

Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has the dates. In order to create customized chart in a userform, for different range of data(i.e from column D, G and M...), I'd like to select a range of rows that are between 2 dates and create the charts accordingly. Or copy to range to another sheet and then create the charts. I am not so advanced in VBA and any help would be greatly appreciated. Thanks! Greg ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore! Free Excel Forum http://www.ozgrid.com/forum *** Hi ...

Can you link 2 worksheets together?
Say i have one worksheet and on my second one I want to reference cells from the first one? is there a formula for that>? To create a simple link: Select a cell in the second worksheet Type an equal sign Select the first sheet Click on the cell that you want to link Press the Enter key. Alesha wrote: > Say i have one worksheet and on my second one I want to reference cells from > the first one? is there a formula for that>? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html ...

Exclude outbound Internet mail from journaling #2
I have an Exchange 5.5 installation which requires message journaling of internal email only. External (Internet) email is captured and archived by a gateway SMTP server, whilst internal mail is journaled to the same SMTP server for archiving. The documentation regarding journaling on Exchange 5.5 details how to route local messages through the MTA, and how to route Internet Mail Service messages through the private information store, but it seems even when this second routing configuration is not applied, outbound internet mail is still being journaled. I need a way to ONLY journal ...

zip code help! #2
thanks for the help !!!!!!!! It worke -- cbender ----------------------------------------------------------------------- cbender3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556 View this thread: http://www.excelforum.com/showthread.php?threadid=27126 ...

Converting from Lotus 1, 2, 3 docs
I have a user who has a bunch of Lotus 1, 2, 3 spreadsheets that he is trying to convert to Excel. His version of Lotus is old (version 5), his version of Excel is 2000 sp2. The files convert but they are missing pages or headings or other unacceptable qualities. Anyone any advice? Michael If you open the files using Excel and save them to an .xls format in the current version you are losing data? A while back I needed to do this. I wrote an application in VB that loops through the files, opens them using Excel (add a reference in VB to MS Office 10) and then save them in the current ...

Start-up #2
Is there any problem in diabling Office 2003 in start- up,it must take a lot of resources for a program of this size. Most of my work is in photography and though I would not like to be without Office, I only use it about ounce a month. theoldone <anonymous@discussions.microsoft.com> wrote: > Is there any problem in diabling Office 2003 in start- > up Of course not. -- Brian Tillman ...