Logical Function excel 2003
Hi,
I have this IF function on one of my cell in my excel sheet IF(G2=327,1,IF(G2=423,2)) - this is my logical test what would the formula for value_if_true? thanks for any help |
Logical Function excel 2003
=IF(G2=327,"value if true","value if false")
=IF(G2=327,1,IF(G2=423,2,"both conditions are false")) In your formula if value is true returns 1 and if false it works on the next condition IF(G2=423,2,"false") If this post helps click Yes --------------- Jacob Skaria "Denver" wrote: Hi, I have this IF function on one of my cell in my excel sheet IF(G2=327,1,IF(G2=423,2)) - this is my logical test what would the formula for value_if_true? thanks for any help |
Logical Function excel 2003
IF(G2=327,1,IF(G2=423,2))
with this formula it gives me a result of 1 but when i change G2 to 423 the result remains 1. how would i correct my formula thanks for any help "Jacob Skaria" wrote: =IF(G2=327,"value if true","value if false") =IF(G2=327,1,IF(G2=423,2,"both conditions are false")) In your formula if value is true returns 1 and if false it works on the next condition IF(G2=423,2,"false") If this post helps click Yes --------------- Jacob Skaria "Denver" wrote: Hi, I have this IF function on one of my cell in my excel sheet IF(G2=327,1,IF(G2=423,2)) - this is my logical test what would the formula for value_if_true? thanks for any help |
Logical Function excel 2003
=IF(G2=327,1,IF(G2=423,2))
The above formula should return 1 for 327 and 2 for 423. Try this in a fresh workbook. Your current cell may be having some formatting. Check whether there are any decimals formatted (not to display)...like 423.01 or so.... If this post helps click Yes --------------- Jacob Skaria "Denver" wrote: IF(G2=327,1,IF(G2=423,2)) with this formula it gives me a result of 1 but when i change G2 to 423 the result remains 1. how would i correct my formula thanks for any help "Jacob Skaria" wrote: =IF(G2=327,"value if true","value if false") =IF(G2=327,1,IF(G2=423,2,"both conditions are false")) In your formula if value is true returns 1 and if false it works on the next condition IF(G2=423,2,"false") If this post helps click Yes --------------- Jacob Skaria "Denver" wrote: Hi, I have this IF function on one of my cell in my excel sheet IF(G2=327,1,IF(G2=423,2)) - this is my logical test what would the formula for value_if_true? thanks for any help |
Logical Function excel 2003
Hi,
I don't think non-displaying decimals could change 423 into 327. The problem you are describing would be a bug if it were try. Feel free to send me a copy of the offending workbook and I will take a look. combine the three last three lines of my salutation. -- If this helps, please click the Yes button. Cheers, Shane Devenshire shanedevenshire. @sbcglobal ..net "Denver" wrote: IF(G2=327,1,IF(G2=423,2)) with this formula it gives me a result of 1 but when i change G2 to 423 the result remains 1. how would i correct my formula thanks for any help "Jacob Skaria" wrote: =IF(G2=327,"value if true","value if false") =IF(G2=327,1,IF(G2=423,2,"both conditions are false")) In your formula if value is true returns 1 and if false it works on the next condition IF(G2=423,2,"false") If this post helps click Yes --------------- Jacob Skaria "Denver" wrote: Hi, I have this IF function on one of my cell in my excel sheet IF(G2=327,1,IF(G2=423,2)) - this is my logical test what would the formula for value_if_true? thanks for any help |
All times are GMT +1. The time now is 01:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com