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 
#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"). 
Ads 
#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 
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 