PC Review


Reply
Thread Tools Rate Thread

Calculation based on entry into one of 2 cells

 
 
dave.cuthill@computalog.com
Guest
Posts: n/a
 
      17th Jul 2007
I am trying to use excel to calculate a result for cell one on entry
into cell two or conversely calculate the value of cell two on entry
into cell one. I have found a solution for this on a previous post I
located using targets and conditional calculations.

The difficulty I have though is I have entries into other cells that
are needed for the calculation and I cannot get the thing to
recalculate based on entries into the other cells or what the proper
logic should be. May on entry into these other cells I null out cell
one and two until all the cells and one of cell one or two have
entries.

What makes sense here??

Thanks for any help.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: Calculation based on a field having a duplicate entry. Cindy Microsoft Access 4 15th Feb 2010 08:06 PM
I need to do a calculation based on the values in two cells NakesGP Microsoft Excel Worksheet Functions 2 23rd Aug 2009 10:33 PM
Sum a column where the cells are based on calculation. HELP blpen Microsoft Excel Programming 1 9th Dec 2008 12:27 AM
Conditional Formatting Based of Cells Based on Data Entry in anoth Jim Microsoft Excel Misc 3 11th Nov 2008 11:52 PM
Populating cells based on calculation =?Utf-8?B?Q2hyaXM=?= Microsoft Excel Worksheet Functions 0 8th Nov 2004 01:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:58 AM.