Formula support

%3CLINGO-SUB%20id%3D%22lingo-sub-1891101%22%20slang%3D%22en-US%22%3EFormula%20support%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1891101%22%20slang%3D%22en-US%22%3E%3CTABLE%20width%3D%22739%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276%22%3E%26nbsp%3BC%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3ED%3C%2FTD%3E%3CTD%20width%3D%2271%22%3EE%3C%2FTD%3E%3CTD%20width%3D%2285%22%3EF%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%26nbsp%3BG%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2287%22%3EH%3C%2FTD%3E%3CTD%20width%3D%2285%22%3E%26nbsp%3BI%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2276%22%3E%26nbsp%3BJ%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3BK%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%200.0355%3C%2FTD%3E%3CTD%3E32%3C%2FTD%3E%3CTD%3E64000%3C%2FTD%3E%3CTD%3E2000%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20640%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%200.010%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202%2C272%3C%2FTD%3E%3CTD%3E%26nbsp%3B%24%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2071%3C%2FTD%3E%3CTD%3E71.8%25%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20formula%20that%20changes%20K%20to%2080%25%20while%20automatically%20changing%20C.%20The%20current%20formula%20for%20K%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D(C-H)%2FC.%20How%20do%20I%20get%20C%20to%20change%20automatically%20by%20raising%20or%20lowering%20K%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1891101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
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
Highlighted

@davem1545 

Enter the following formula in C1:

=5*H1