Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Cross reference

a simple excel, I have 4 columns in my excel

A is for checking
B is the price or product
C is profit
D is cost

what i want to do is simple, I set formular in C & D, once a user
input either C or D, the another cell will show the different. i.e.

if C is input, D=B-C
if D is input, C=B-D

then A is checking purpose, if either C or D is inputted, it will
shown "Y"

but if I use IF(D0, B-D, "") it will introduce cyclic reference.

any solution for this?
Thanks.
 
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
cross reference two spreadsheets MAD101 Excel Discussion (Misc queries) 1 October 20th 08 02:55 AM
cross reference two auntieb New Users to Excel 3 September 8th 08 05:17 PM
Cross reference LaRana! Excel Worksheet Functions 1 March 6th 08 12:22 AM
Cross Reference between sheets JP Excel Worksheet Functions 2 May 14th 06 01:36 PM
Cross Reference Terrance DeBord Excel Worksheet Functions 1 March 8th 06 04:11 PM


All times are GMT +1. The time now is 06:06 PM.

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

About Us

"It's about Microsoft Excel"