| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement!!
Hello, I have an excel dilemma. Basically i need an advanced IF statement. It needs to look at a cell first and if that Cell is greater than the number one it needs to return fail for the whole formula, if it is less than one it needs to check another field and if that is one or less it will return a 'pass'. This is how i think it should look, =IF(D151,"Fail", IF(F151, "Pass")) I think im wrong though!! Thanks in advance for your help! -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
one <if is more than enough.
you may do it this way: =if(d15criteria,"fail", "pass") to read: id d15 is bigger than whatever then write a fail otherwise write a pass. "PaulOakley" wrote: Hello, I have an excel dilemma. Basically i need an advanced IF statement. It needs to look at a cell first and if that Cell is greater than the number one it needs to return fail for the whole formula, if it is less than one it needs to check another field and if that is one or less it will return a 'pass'. This is how i think it should look, =IF(D151,"Fail", IF(F151, "Pass")) I think im wrong though!! Thanks in advance for your help! -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
=IF(D151,"Fail", IF(F15<=1, "Pass")) "PaulOakley" wrote: Hello, I have an excel dilemma. Basically i need an advanced IF statement. It needs to look at a cell first and if that Cell is greater than the number one it needs to return fail for the whole formula, if it is less than one it needs to check another field and if that is one or less it will return a 'pass'. This is how i think it should look, =IF(D151,"Fail", IF(F151, "Pass")) I think im wrong though!! Thanks in advance for your help! -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
sorry, i misread the question. please drop my solytion.
"GG" wrote: one <if is more than enough. you may do it this way: =if(d15criteria,"fail", "pass") to read: id d15 is bigger than whatever then write a fail otherwise write a pass. "PaulOakley" wrote: Hello, I have an excel dilemma. Basically i need an advanced IF statement. It needs to look at a cell first and if that Cell is greater than the number one it needs to return fail for the whole formula, if it is less than one it needs to check another field and if that is one or less it will return a 'pass'. This is how i think it should look, =IF(D151,"Fail", IF(F151, "Pass")) I think im wrong though!! Thanks in advance for your help! -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
Hi
One problem is that if the first IF is TRUE, it will not get to the second IF. What happens if D15<1 and F15 <1? What if D151 and F151? Food for thought. Andy. "PaulOakley" wrote in message ... Hello, I have an excel dilemma. Basically i need an advanced IF statement. It needs to look at a cell first and if that Cell is greater than the number one it needs to return fail for the whole formula, if it is less than one it needs to check another field and if that is one or less it will return a 'pass'. This is how i think it should look, =IF(D151,"Fail", IF(F151, "Pass")) I think im wrong though!! Thanks in advance for your help! -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
On Wed, 29 Mar 2006 05:27:25 -0600, PaulOakley
wrote: Hello, I have an excel dilemma. Basically i need an advanced IF statement. It needs to look at a cell first and if that Cell is greater than the number one it needs to return fail for the whole formula, if it is less than one it needs to check another field and if that is one or less it will return a 'pass'. This is how i think it should look, =IF(D151,"Fail", IF(F151, "Pass")) I think im wrong though!! Thanks in advance for your help! =IF(D15<=1,IF(F15<1,"Pass","Undefined"),"Fail") --ron |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
Hi, Im still having problems with this, I have attached a zip file of the document to try and show the problem more clearly, I have annotated the sheet. Its really difficult trying to explain the problem in words! Thanks in advance for your help, Paul +-------------------------------------------------------------------+ |Filename: Audit.zip | |Download: http://www.excelforum.com/attachment.php?postid=4547 | +-------------------------------------------------------------------+ -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
I've clicked on your link and it says 'Invalid attachment'
Andy. "PaulOakley" wrote in message ... Hi, Im still having problems with this, I have attached a zip file of the document to try and show the problem more clearly, I have annotated the sheet. Its really difficult trying to explain the problem in words! Thanks in advance for your help, Paul +-------------------------------------------------------------------+ |Filename: Audit.zip | |Download: http://www.excelforum.com/attachment.php?postid=4547 | +-------------------------------------------------------------------+ -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
Here it is again, hopefully it will work this time +-------------------------------------------------------------------+ |Filename: Audit.zip | |Download: http://www.excelforum.com/attachment.php?postid=4548 | +-------------------------------------------------------------------+ -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
Nope, sorry!
Andy. "PaulOakley" wrote in message ... Here it is again, hopefully it will work this time +-------------------------------------------------------------------+ |Filename: Audit.zip | |Download: http://www.excelforum.com/attachment.php?postid=4548 | +-------------------------------------------------------------------+ -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
Hi Paul
Try =IF(I9="Fail","Fail",IF(AND(H19<1,I19<2),"Pass","F ail")) -- Regards Roger Govier "PaulOakley" wrote in message ... Here it is again, hopefully it will work this time +-------------------------------------------------------------------+ |Filename: Audit.zip | |Download: http://www.excelforum.com/attachment.php?postid=4548 | +-------------------------------------------------------------------+ -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
See if this works =IF(H19=0,IF(I19<2,"Pass","Fail"),"Fail") -- Infinity ------------------------------------------------------------------------ Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statement!!
Thanks guys, works perfectly cheers for your help, and preventing a fist and a monitor coming into contact! Cheers Paul -- PaulOakley ------------------------------------------------------------------------ PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103 View this thread: http://www.excelforum.com/showthread...hreadid=527527 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reconcile two months statement? | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
Linear Mode
