RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Guys
I am trying to write one single formula in cell K2 and drag it down the get the same result entered manually in cell I2. There is multiple If conditions in the formula. I have tried to explain by writing each condition separately so that you will understand what I am trying to achieve.
IF A2 ="Receipt", -F2…..IF A2 ="Payment", F2….IF A2= "Contra", if E2="",F2…….IF A2= "Contra", if E2<>-F2.
Please I need help to put all these conditions in one formula to enter in one cell. Columns A, E and F only are connected to the formula. Others are just extra columns of the data.
I am trying to write one single formula in cell K2 and drag it down the get the same result entered manually in cell I2. There is multiple If conditions in the formula. I have tried to explain by writing each condition separately so that you will understand what I am trying to achieve.
IF A2 ="Receipt", -F2…..IF A2 ="Payment", F2….IF A2= "Contra", if E2="",F2…….IF A2= "Contra", if E2<>-F2.
Please I need help to put all these conditions in one formula to enter in one cell. Columns A, E and F only are connected to the formula. Others are just extra columns of the data.
Query multiple if function.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | TYPE | DATE | No. | PARTICULARS | Withdrawals | Receipts | XXXXX | Result | Enter Formula Here | ||||
2 | Receipt | 02-04-2021 | 1 | April | 1000 | AAAA | -1000 | ||||||
3 | Payment | 02-04-2021 | 2 | Friday | 2000 | BBBB | 2000 | ||||||
4 | Contra | 02-04-2021 | 3 | Cash | 3000 | CCCC | 3000 | ||||||
5 | Contra | 02-04-2021 | 4 | Cash | 4000 | DDDD | -4000 | ||||||
QUERY |