Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Formula with three conditions

Hi gurus, I just need help from you, I am working with a journal entry template, I want that posting key cell will (cells A1:A43) will be populated when amounts are entered in cells D1:D43, when value in Cell D1 is positive amount, cell A1 will be “40”, if D1 is negative amount, cell A1 will be “50”, it sound easy, but there are two additional conditions:
1. One of them is related cells (C1:C43), it can be blank or be entered a text of 1 character, C1 itself does not change the posting key in A1, but C1 combined with D1 if change A1, I mean when D10 and C1<””, then A1=”09” if D1<0 and C1<””, then A1=”19”. I mean A1 will be “09” or “19” when C1<””, not dependency of Cell B1. I did a formula as follow and works perfectly: =IF(D1<””,(IF((AND(C1=””),(IF(D10,”40”,”50”)),(I F(AND(C1<””,D10),”09”,”19”)))),””)
2. Last condition is related to cell B1 (General ledger account), they can have a LEN of 6 characters and only have dependency of D1 (not dependency of cell C1), in this case if D10 and LEN B1=6, then A1=”40”, if not A1=”50”. If C1<6 and D10, A1=”24”, if not A1=”34”. I did a formula for this statement as follow: =IF(D1<””,(IF(AND(LEN(B1)6),(IF(D10,”24”,”34”)) ,(IF(AND(LEN(B1)<””,D10),”40”,”50”)))),””).
Now I want to combine these two formulas, so far I have cannot to do it because I think there is a conflict of result. Can you look at a solution for me?
Attached Files
File Type: txt test.txt (483 Bytes, 60 views)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP!! Formula with different conditions Teri Excel Worksheet Functions 5 February 17th 10 09:04 PM
Formula with 2 conditions Joey Excel Discussion (Misc queries) 2 April 18th 08 04:38 PM
IF formula for 3 possible conditions cbgraphics Excel Discussion (Misc queries) 6 December 28th 06 03:22 PM
Formula With Several Conditions Chris Excel Worksheet Functions 1 November 14th 06 02:38 PM
Help for a formula using two conditions harwookf Excel Worksheet Functions 7 November 24th 04 09:21 AM


All times are GMT +1. The time now is 01:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"