How to Make Nested IF's ?

[oskar270]

I made this formula but it is not exactly what I wanted
=IF(LEFT(C314,4)="Groc",IF(E314="",-D314,0))

I want to say: if column C has the string “Groc” and column E has nothing, put the value of D, but if column E has a value then put this value.

To further explain, column C contains a string which assigns a transaction to a particular column, column E contains debits to my bank balance and column D contains cash payments.

So if my payment is a debit payment (means column E has a value and column D has nothing) I want to record this payment but if it is a cash payment (means column E has nothing and column D has a value) then I want to record this payment.

If I remember the formula I want it is called “nested IF’s” ?

Thank you

[zbor]

Nested IF's means that there are few IF function ...

maybe this?

=IF(LEFT(C314,4)="Groc",IF(E314="",D314,E314))

[abousetta]

Maybe less IFs and more ANDs is what the doctor ordered:

Please Login or Register  to view this content.

abousetta

[ChemistB]

I'll assume that if C doesn't have "groc" you'll want blank returned.

=IF(LEFT(C314,4)="Groc",IF(E314="",D314,E314),"")

[zbor]

What if no Groc in C?

[abousetta]

From the OP's statement "if column C has the string “Groc” and column E has nothing, put the value of D, but if column E has a value then put this value" then I believe that if all conditions are fullfilled then the value in Column D, but if not then Column E... unless of course he meant something else (in which I case I need to go to work )

abousetta

[abousetta]

Help me oskar270... the forum Gurus are after me... Save me...

[oskar270]

From the OP's statement "if column C has the string “Groc” and column E has nothing, put the value of D, but if column E has a value then put this value" then I believe that if all conditions are fullfilled then the value in Column D, but if not then Column E... unless of course he meant something else (in which I case I need to go to work )

abousetta

No I dont mean anything else, what you say is correct but I think the formula from "ChemistB" suits my needs best and that is what I try now

Thank you all for the help

[oskar270]

I'll assume that if C doesn't have "groc" you'll want blank returned.

=IF(LEFT(C314,4)="Groc",IF(E314="",D314,E314),"")

Thank you ChemistB for noticing my error,

I forgot to mention that if C doesn't have "groc" I want blank returned. Your formula is simple and gives me what I want

Thanks

[ChemistB]

"Simple" is my middle name. Glad to help

[abousetta]

If you are satisfied with the responses, could you mark the thread as Solved.

abousetta

[oskar270]

If you are satisfied with the responses, could you mark the thread as Solved.

abousetta

Dont know how to mark the thread solved but noticed in another thread it was written like that.

Thank you all SOLVED