Is this even possible?

[deleriumbliss]

Hey all. I tried using IF and I can't seem to get it to work.
Using a basic checkbook worksheet (debit/credit total left in account etc...)

Budget of $500 (starting amount)
if amount spent (50) is being split 2 ways, in column b, i'd put then YES. Cell C would need the equation (500-(50/2) =475 if "NO", then 500-50=450. Going all the way down the rows, possibly 60 or more.

Is this even possible? Thank you in advance

 

[mrshl9898]

Sounds simple enough.

Can you provide some sample data? It's important to understand where the data is located in the table.

 

[Scott Huish]

Put your starting amount in C1.
In C2:
=IF(A2="","",C1-IF(B2="YES",A2/2,A2))
Copy down.

Excel 2010
	A	B	C
1			$ 500.00
2	$ 50.00	YES	$ 475.00
3	$ 50.00	NO	$ 425.00
4
5
6
7
8
9
10
11
12
13
Sheet1

Cell Formulas
Range	Formula
C2	=IF(A2="","",C1-IF(B2="YES",A2/2,A2))
C3	=IF(A3="","",C2-IF(B3="YES",A3/2,A3))
C4	=IF(A4="","",C3-IF(B4="YES",A4/2,A4))
C5	=IF(A5="","",C4-IF(B5="YES",A5/2,A5))
C6	=IF(A6="","",C5-IF(B6="YES",A6/2,A6))
C7	=IF(A7="","",C6-IF(B7="YES",A7/2,A7))
C8	=IF(A8="","",C7-IF(B8="YES",A8/2,A8))
C9	=IF(A9="","",C8-IF(B9="YES",A9/2,A9))
C10	=IF(A10="","",C9-IF(B10="YES",A10/2,A10))
C11	=IF(A11="","",C10-IF(B11="YES",A11/2,A11))

 

[jtakw]

Hi,

Don't know how your data is setup, adapt this to your sheet:

Book1
	A	B	C	D
1	Spent	Split Yes/No	Budget	500
2	50	Yes		475
3	50	No		425
Sheet356

Cell Formulas
Range	Formula
D2	=D1-A2/IF(B2="Yes",2,1)

Formula copied down.

 

[deleriumbliss]

Scott! That is EXACTLY what I needed. Works PERFECTLY ☺ Thank you so very much!!

 

[jtakw]

Don't mine work as well??
If you need D to be Blank when A has no value, just add a Blank check:

Book1
	A	B	C	D
1	Spent	Split Yes/No	Budget	500
2	50	Yes		475
3	50	No		425
4
5
6
Sheet356

Cell Formulas
Range	Formula
D2	=IF(A2="","",D1-A2/IF(B2="Yes",2,1))