| 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 |
| 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 | |||
Threaded Mode
