Help with IF function

[bluegreen]

Hi All,

I am working on a spreadsheet with a total and a separate column with options Y or N.

X	TOTAL	VALUE	TOTAL - ANY Y
X1	SUM X	Y/N	SUM X- ANY Y

I want to use a formula to the effect of IF value=Y, subtract value X1 from the SUM X, IF value=N, do nothing.

Any help would be greatly appreciated.
Cheers

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D
1
2	1	1	Y	0
3	2	3	N
4	3	6	N
5	4	10	N
6	5	15	Y	10
7	6	21	Y	15
8	7	28	N
Master

Cell Formulas
Range	Formula
B2:B8	B2	=SUM(A$2:A2)
D2:D8	D2	=IF(C2="Y",B2-A2,"")

 

[Sufiyan97]

Hi & Welcome to MrExcel.

Try

Products.xlsx
	A	B	C	D	E
1	X	TOTAL	VALUE	TOTAL - ANY Y
2	X1	SUM X	Y/N	SUM X- ANY Y
3	1	5	Y	4
4	1	5	N
5
6
Sheet8

Cell Formulas
Range	Formula
D3:D4	D3	=IF(C3="Y",B3-A3,"")