Home 
Search 
Today's Posts 
#11




Create a conditional formula that results in another calculati
"JCPS" wrote: "T. Valko" wrote: You're welcome!  Biff Microsoft Excel MVP "dyrret" wrote in message ... Thanks again. "T. Valko" wrote: If *neither* cell contains a number then the formula returns a blank. The "" is the syntax for "blank". If you'd rather have a 0 returned: =IF(COUNT(A2),A2/4.54,IF(COUNT(B2),B2*0.83,0)) Or, you could return an informational message like "no value entered": =IF(COUNT(A2),A2/4.54,IF(COUNT(B2),B2*0.83,"no value entered")) Using the COUNT function ensures that a number has been entered in one or the other cells. It prevents errors if someone accidentally enters a text string or if one of the cells already contains an error. It may not be necessary but it makes things robust and doesn't add undue complexity to the formula.  Biff Microsoft Excel MVP "dyrret" wrote in message ... One question re the answer: I understand what is being "said" except the double quotation marks. "T. Valko" wrote: Try this: =IF(COUNT(A2),A2/4.54,IF(COUNT(B2),B2*0.83,""))  Biff Microsoft Excel MVP "dyrret" wrote in message ... I'm just learning to use Excel. I want to enter data in either column A (litres) OR column B (US gallons). Column C will convert to imperial gallons. I would like to create a formula in column C that would result in this logic: IF there is data in cell "A(n)" then do calculation A(n)/4.54, if no data in A(n) and there is data in cell "B(n)" then do calculation B(n)*.83 Hello T. Valko. I just went through the formula on the discussion of 083108 responding to dyrret asking: "I'm just learning to use Excel. I want to enter data in either column A (litres) OR column B (US gallons). Column C will convert to imperial gallons. I would like to create a formula in column C that would result in this logic: IF there is data in cell "A(n)" then do calculation A(n)/4.54, if no data in A(n) and there is data in cell "B(n)" then do calculation B(n)*.83" So do I. I'm learning use Excel WorkSheet. But instead of a column as mentioned before, I need a single cell like AB shows on decimal equivalent of minutes or hour with minutes, example, AC  15 minutes = mathematical formula would be, 15 x .01666667 = .25 this decimal equivalent of 15 min AC  1hour 35minutes (1.35) = 1.583 this results on AB, and minutes on AC. I tried modified the one suggested here before but failed. Any help will be significant. Thanks T. Valko, I already found it, =IF(COUNT(AB19),AB19*(AC9),"<<Enter Time"). 
#12




hi guys,
i think this thread may be the place i need to find out a similar conditional formula, i need a cell (K) to make a calculation based on IF the previous cell (I) goes below 1.5 X the value of a cell (J)  the calculation needs to be the difference between cell (I) and 1.5 X the value of cell (J) IF it isnt below 1.5 X cell (J) THEN return blank cell i think thats what i need i might be overthinking this but any help would be appreciated. thanks jimmy 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
i want to create an IF formula to bring back one of four results .  Excel Worksheet Functions  
Calculation results as static data not formula.  Excel Worksheet Functions  
Conditional Sum Argument results do not equal cell results Excel  Excel Worksheet Functions  
create time calculation formula  Excel Discussion (Misc queries)  
create a conditional formula  Excel Worksheet Functions 