Is There Any Tips For The Following Problems

Originally Posted by mmca2006

IS THERE ANY TIPS FOR THE FOLLOWING PROBLEMS---------

(1)

CELL C2= If( A2=2, A2*B2, Any Value I put in Cell C 2 )




I want that , If A2 =2 ,C2 will be B2*A2,otherwise any value I put into C but the problem is that when I am putting any value in C2, the original formula is being erased and cannot be used again when A2 becomes 2 .
Is it possible to get the freedom of entering any value in C2 when A2<> 2 ,without loosing the formula in CELL C2.

(2)

CELL C1= if (A1= “ Thousand ” , Value of C1 is to divided by1000 , otherwise value will be value of C1 which I put in Cell C 1 )

Is it possible by any formula , kindly suggest shall be obliged .

Hi,

one option is to have C as a 'helper' column and use columns A B & D, where D2 =

=If(A2<>"",B2*A2,C2)

where C2 can be font = white on white (hidden) or the column can be hidden.

Same answer for problem 2, D1 =

=If(A1="",C1,C1/A1)

hth
---