|Posted: March 2, 2010, 8:16 pm - IP Logged|
yes i got that part Carl..Thanks!
now how will it consistently know to output the mirror numbers in d,e,f?
JB you say you are new to Excel, I may not understand your question in which case ask again.
the formula in cell D tells Excell to add 5 (mirrow) to the value in cell A, likewise cell E adds 5 to the value in B etc
the mod at the beginning and the 10 at the end of the formula in cells DEF tell Excell what the maximum value can be.
once you have these formulas entered you don't do anything else with them. you only see the result.
when you change any value, excel will recalculate, if recalc is on (default). with the formulas entered change the value in A then move off that cell, the value in D should have changed.
do the same for B or C and as soon as you move to a different cell it updates
Excel can be frustrating but it's worth learning if you play with numbers.
the only stupid question is the one you don't ask, when you don't understand something