Help with "if"
is there a way of inputing say
=if(a4 is between 6 and 8) so to get a true response and a false a4 = say 6.5 please help |
Help with "if"
Hi, The formula below should work - =IF((AND(B46,B4<8)),\"TRUE\",\"FALSE\") Where B4 is the cell where the number is. So what the formula is saying is if B4 is greater than 6 and less than 8 then enter "True", otherwise enter "False". This formula will show 6 and 8 as "false". If you want to change it to show 6 and 8 as true change the formula to : =IF((AND(B4=6,B4<=8)),\"TRUE\",\"FALSE\") hope this answers your question Steven -- Steven_Archer ------------------------------------------------------------------------ Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025 View this thread: http://www.excelforum.com/showthread...hreadid=487581 |
Help with "if"
Hi Bob
=IF(AND(A4=6,A4<=8),"true response","false response") Regards Roger Govier Bob wrote: is there a way of inputing say =if(a4 is between 6 and 8) so to get a true response and a false a4 = say 6.5 please help |
Help with "if"
=AND(A4<=6,A4=8)
-- HTH RP (remove nothere from the email address if mailing direct) "Bob" wrote in message ... is there a way of inputing say =if(a4 is between 6 and 8) so to get a true response and a false a4 = say 6.5 please help |
Help with "if"
Thank you
"Steven_Archer" wrote: Hi, The formula below should work - =IF((AND(B46,B4<8)),\"TRUE\",\"FALSE\") Where B4 is the cell where the number is. So what the formula is saying is if B4 is greater than 6 and less than 8 then enter "True", otherwise enter "False". This formula will show 6 and 8 as "false". If you want to change it to show 6 and 8 as true change the formula to : =IF((AND(B4=6,B4<=8)),\"TRUE\",\"FALSE\") hope this answers your question Steven -- Steven_Archer ------------------------------------------------------------------------ Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025 View this thread: http://www.excelforum.com/showthread...hreadid=487581 |
Help with "if"
Thank you
"Steven_Archer" wrote: Hi, The formula below should work - =IF((AND(B46,B4<8)),\"TRUE\",\"FALSE\") Where B4 is the cell where the number is. So what the formula is saying is if B4 is greater than 6 and less than 8 then enter "True", otherwise enter "False". This formula will show 6 and 8 as "false". If you want to change it to show 6 and 8 as true change the formula to : =IF((AND(B4=6,B4<=8)),\"TRUE\",\"FALSE\") hope this answers your question Steven -- Steven_Archer ------------------------------------------------------------------------ Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025 View this thread: http://www.excelforum.com/showthread...hreadid=487581 |
Help with "if"
thank you
"Roger Govier" wrote: Hi Bob =IF(AND(A4=6,A4<=8),"true response","false response") Regards Roger Govier Bob wrote: is there a way of inputing say =if(a4 is between 6 and 8) so to get a true response and a false a4 = say 6.5 please help |
Help with "if"
thank you
"Bob Phillips" wrote: =AND(A4<=6,A4=8) -- HTH RP (remove nothere from the email address if mailing direct) "Bob" wrote in message ... is there a way of inputing say =if(a4 is between 6 and 8) so to get a true response and a false a4 = say 6.5 please help |
Help with "if"
Shorter, but perhaps not as clear:
=ABS(A4-7)<=1 -- Dana DeLouis Win XP & Office 2003 "Bob" wrote in message ... is there a way of inputing say =if(a4 is between 6 and 8) so to get a true response and a false a4 = say 6.5 please help |
All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com