|
Calling all Excel gurus...A question regarding formulas
Posted 4/3/2012 1:01:20 PM by HoneyBadger Can I set up a conditional formula? For example: I would like to have a*b=c BUT if it's multiplied by ten it will automatically calculate to a different (technically incorrect) answer. Meaning 2*225= 450 but if it's 10*225=2000. Ya dig? Is this possible and if so how do I set up the formula? Thanks :) |