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]

if b2="1) E02 emergency", then Colmn e-colmn D Else, Column D- C and diplay the result as pass or fail#

<colgroup><col width="104"></colgroup><tbody>
</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..

priority description	target date	action completed	at site timestamp
1) E02 Emergency	01/08/2014 07:23	01/08/2014 11:54	01/08/2014 11:22
5) R20 Routine	01/09/2014 08:29	11/08/2014 15:00

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[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 ?