Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get 1 cell calculate only if another cell has an "x"
=(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10))
I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Hi Rochelle
you only wnat the formula to display an answer if J14 has an "x"? then try =IF(J14="X",IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10),"") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10)) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#4
|
|||
|
|||
Please forgive me for my lack of understanding...
how does the 1,2 fit in? "Don Guillett" wrote: =if(j14="x",1,2) -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10 )) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#6
|
|||
|
|||
I would say that Don doesn't like to type as much as Julie does.<bg
The 1 and 2 represent the first and second parts of your original formula. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Rochelle B" wrote in message ... Please forgive me for my lack of understanding... how does the 1,2 fit in? "Don Guillett" wrote: =if(j14="x",1,2) -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10 )) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#7
|
|||
|
|||
type, who types .. cut & paste works just as well :)
-- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Ragdyer" wrote in message ... I would say that Don doesn't like to type as much as Julie does.<bg The 1 and 2 represent the first and second parts of your original formula. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Rochelle B" wrote in message ... Please forgive me for my lack of understanding... how does the 1,2 fit in? "Don Guillett" wrote: =if(j14="x",1,2) -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10 )) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#8
|
|||
|
|||
So ... Don doesn't like to cut and paste as much as Julie does.<vbg
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JulieD" wrote in message ... type, who types .. cut & paste works just as well :) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Ragdyer" wrote in message ... I would say that Don doesn't like to type as much as Julie does.<bg The 1 and 2 represent the first and second parts of your original formula. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Rochelle B" wrote in message ... Please forgive me for my lack of understanding... how does the 1,2 fit in? "Don Guillett" wrote: =if(j14="x",1,2) -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10 )) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#9
|
|||
|
|||
THANKS
"JulieD" wrote: Hi Rochelle you only wnat the formula to display an answer if J14 has an "x"? then try =IF(J14="X",IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10),"") -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10)) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#10
|
|||
|
|||
THANKS!
"Don Guillett" wrote: substitute your needs instead of 1,2 if true then 1 else 2 -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... Please forgive me for my lack of understanding... how does the 1,2 fit in? "Don Guillett" wrote: =if(j14="x",1,2) -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10 )) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
#11
|
|||
|
|||
Or type
-- Don Guillett SalesAid Software "Ragdyer" wrote in message ... So ... Don doesn't like to cut and paste as much as Julie does.<vbg -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "JulieD" wrote in message ... type, who types .. cut & paste works just as well :) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ...well i'm working on it anyway "Ragdyer" wrote in message ... I would say that Don doesn't like to type as much as Julie does.<bg The 1 and 2 represent the first and second parts of your original formula. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Rochelle B" wrote in message ... Please forgive me for my lack of understanding... how does the 1,2 fit in? "Don Guillett" wrote: =if(j14="x",1,2) -- Don Guillett SalesAid Software "Rochelle B" wrote in message ... =(J14="X")*(IF(EVEN(H14)*EVEN(E14)/144J10,EVEN(H14)*EVEN(E14*C14)/144,$J$10 )) I do not want the * after (j14="x") I just want this formula to calculate the formula based on if j14 has an x in it. Excel wants to put the * I just want a comma. The formula is not calulating correctly due to this. fyi: this formula is calculating Sq ft of glass, it is costly if the formula is wrong Please help, I need to have this ready to go Monday morning. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |