Multiple IF Formulas

[didier]

Hello guys,

need your help

i have the below table

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Qty[/TD]
[TD]Received[/TD]
[TD]Missing[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]50[/TD]
[TD]10[/TD]
[TD]=A3-B3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


i need to create a formula in D3 that will do the following:

IF C3 is empty D3 is empty
IF C3 is lower then A2 = Pending
IF C3 is equil to B3 = Completed

Thank you for the help

 

[Joe4]

Try:

=IF(C3="","",IF(C3 < A3,"Pending",IF(C3=B3,"Completed","???")))

<a3,"pending",if(c3=b3,"completed","???")))[ code]<="" html=""></a3,"pending",if(c3=b3,"completed","???")))[>

 

[didier]

Hey Joe4,

thank you for the try however there are 2 issues,

once C3 = 0, it must say complete, now it says pending(C3 has a formula in it A3-B3)
if there is no data in A3 and B3, now it says completed, it should be blank

 

[Joe4]

once C3 = 0, it must say complete, now it says pending(C3 has a formula in it A3-B3)

So are you now saying that if C3=0, it should always say complete, even if C3 is less than A3 in this instance?

if there is no data in A3 and B3, now it says completed, it should be blank

You seem to be adding more and more conditions that you did not mention in your original post.
Rather than giving them piece-meal to us, can you give them all to us at once?
Are there any other situations you haven't addressed yet?

If there are no other conditions, then this should satisfy all that you have said thus far:

=IF(OR(C3="",AND(A3="",B3="")),"",IF(OR(C3=B3,C3=0),"Completed",IF(C3 < A3,"Pending","???")))