Formula support

Occasional Visitor
 C DEF G H I  J  K 
 $     0.035532640002000 $                    640 $          0.010 $          2,272 $            7171.8%

 

I need a formula that changes K to 80% while automatically changing C. The current formula for K is:

 

=(C-H)/C. How do I get C to change automatically by raising or lowering K?

 

1 Reply

@davem1545 

Enter the following formula in C1:

=5*H1