Home 
Search 
Today's Posts 
#1




Create a conditional formula that results in another calculation
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 
#2




Create a conditional formula that results in another calculation
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 
#3




Create a conditional formula that results in another calculati
Thankyou,
Works wonderfully and makes sense when I see it. I was trying to construct something too complicated....missed the more straight forward answer. dyrret "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 
#4




Create a conditional formula that results in another calculati
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 
#5




Create a conditional formula that results in another calculati
That's an empty string, so if you have no data in A or B your result will be
blank instead of zero or the boolean FALSE.  David Biddulph "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 
#6




Create a conditional formula that results in another calculati
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 
#7




Create a conditional formula that results in another calculati
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 
#8




Create a conditional formula that results in another calculati
Thank you.....seeing examples and getting explanations is helping me learn.
"David Biddulph" wrote: That's an empty string, so if you have no data in A or B your result will be blank instead of zero or the boolean FALSE.  David Biddulph "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 
#9




Create a conditional formula that results in another calculati
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 
#10




Create a conditional formula that results in another calculati
"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. 
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 