If else with criteria

[nicci113]

Hi There,

I'm stuck with a simple if else query and need a bit of guidance.

what I'm trying to do is compare 2 dates based on the condtion from different cell and if condition gets statisfy put pass else put fail..

Can you please guide me? I know its not that difficult i just need a bit of heads up.

thanks

 

[gaz_chops]

You need to provide a bit more info.
What are the cell references?
What is the condition?

 

[nicci113]

<colgroup><col width="104"></colgroup><tbody>
[TD="width: 104"]if b2="1) E02 emergency", then Colmn e-colmn D Else, Column D- C and diplay the result as pass or fail#
[/TD]

</tbody>

I hope it help, I don't get option to upload the document. below is the sample data, what I need is where priority desc is "emergency" calc action complete - target date else and display the result as pass or fail..


[TABLE="width: 471"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]priority description[/TD]
[TD]target date[/TD]
[TD]action completed[/TD]
[TD]at site timestamp[/TD]
[/TR]
[TR]
[TD]1) E02 Emergency[/TD]
[TD="align: right"]01/08/2014 07:23[/TD]
[TD="align: right"]01/08/2014 11:54[/TD]
[TD="align: right"]01/08/2014 11:22[/TD]
[/TR]
[TR]
[TD]5) R20 Routine[/TD]
[TD="align: right"]01/09/2014 08:29[/TD]
[TD="align: right"]11/08/2014 15:00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

If you do "Colmn e-colmn D Else, Column D- C", how do you know if it is Pass or Fail?

 

[nicci113]

those columns are dates, so if the earlier date is lesser the latar its a fail else pass.

 

[gaz_chops]

those columns are dates, so if the earlier date is lesser the latar its a fail else pass.

OK you originally said "calc action complete minus target date"!

Try

​=IF(B2="1) E02 Emergency",IF(D2<=C2,"Pass","Fail"),"")

 

[nicci113]

OK you originally said "calc action complete minus target date"!

Try

​=IF(B2="1) E02 Emergency",IF(D2<=C2,"Pass","Fail"),"")

cheers mate it does work, could you please give me a syntax if I want to add condition to it where it doesnt equal to which i think is <> but doesn that if statement goes withiin "" you have entered in teh end?

Apperciate your help!

 

[gaz_chops]

You're welcome, it depends on how you want to check for <>? It could be

=IF(B2="1) E02 Emergency",IF(D2<=C2,"Pass",IF(??<>??,??,"Fail")))

 

[nicci113]

You're welcome, it depends on how you want to check for <>? It could be

=IF(B2="1) E02 Emergency",IF(D2<=C2,"Pass",IF(??<>??,??,"Fail")))

cheers bud! exactly what I was looking for.. Lifesaver

have a nice weekend..

 

[gaz_chops]

You're welcome, you too ?