Hi
I have the following sample:
B C D E F
Old $ Discr. New $ % Inc. Net Inc.
11,960 2000 13,960 17% 2,000
18,730 6% 19,798 6% 1,068
8,500 100 8,600 1% 100
7,000 11.20% 7,784 11% 784
11,250 550 11,800 5% 550
My problem:
1. How can I lock cell C to only have either % or # value. And, if % was input earlier - when people want to change to #, the % will be overwritten. (in the attached, try to change 6% to 600 - it will be 600%, whereas it should be 600)
2. Based on column C, column D formula will be:
IF # then B + C
IF % then B + (B x C)
3. Lock the #/% i.e. column C (be it in # or %) should be more than 20% of column B - if it is more than 20% - either they cannot put the number/% or, error message come out ...
Thanks - Bert
Bookmarks