please help me with this

%3CLINGO-SUB%20id%3D%22lingo-sub-2153811%22%20slang%3D%22en-US%22%3Eplease%20help%20me%20with%20this%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153811%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20enter%20a%20formula%20that%20gives%20me%20the%20results%20in%20the%20equation%20below.%3C%2FP%3E%3CP%3E25-17.45%3D7.55*10338%3D78053%2F21000.3%3D3.72%3C%2FP%3E%3CP%3Ewhen%20I%20enter%20%3Dif(c6-c7%26lt%3B%3D0%2C%220%22%2Cc6-c7*10338%2F21000.3)%20I%20get%2014.89%3C%2FP%3E%3CP%3E3.72%20is%20the%20correct%20answer%20that%20I%20need.%26nbsp%3B%20My%20only%20cell%20references%20are%20in%20column%20C.%3C%2FP%3E%3CP%3EI've%20been%20doing%20the%20calculation%20on%20my%20phone%20and%20thought%20I%20could%20just%20add%20a%20column%20and%20put%20in%20the%20formula%20and%20have%20the%20answer%20right%20there.%26nbsp%3B%20(3.72%20tells%20me%20I%20will%20need%203.72%20hours%20to%20fill%20my%20water%20tank.)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I'm trying to enter a formula that gives me the results in the equation below.

25-17.45=7.55*10338=78053/21000.3=3.72

when I enter =if(c6-c7<=0,"0",c6-c7*10338/21000.3) I get 14.89

3.72 is the correct answer that I need.  My only cell references are in column C.

I've been doing the calculation on my phone and thought I could just add a column and put in the formula and have the answer right there.  (3.72 tells me I will need 3.72 hours to fill my water tank.)

0 Replies