If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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 
Ads 
#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. 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
i want to create an IF formula to bring back one of four results .  vsors  Excel Worksheet Functions  4  August 26th 08 06:16 PM 
Calculation results as static data not formula.  tcidawn  Excel Worksheet Functions  4  September 12th 07 05:12 PM 
Conditional Sum Argument results do not equal cell results Excel  Randy R Mullins  Excel Worksheet Functions  3  August 9th 06 07:16 PM 
create time calculation formula  Jcraig713  Excel Discussion (Misc queries)  3  June 28th 06 01:24 PM 
create a conditional formula  Matt H.  Excel Worksheet Functions  1  October 9th 05 03:57 AM 