|
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. |
|
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
| All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com