Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cross reference two spreadsheets | Excel Discussion (Misc queries) | |||
cross reference two | New Users to Excel | |||
Cross reference | Excel Worksheet Functions | |||
Cross Reference between sheets | Excel Worksheet Functions | |||
Cross Reference | Excel Worksheet Functions |