Complete a formula is a previous statement is true

[RobA]

I'm a novice at excel and would like a formula to only work if a previous statement is true.

The example is I have a formula for predicted figures for the next year which is worked out from our current monthly figures / 4 * 52 to predict a rough figure of next years.

This is same formula is run on over 100 rows of data from different vendors.

However I plan on putting a cell in each column which will show if the customer is active or inactive and would only like the above formula to work only if the cell is shows "active"

If the cell shows "inactive" the sum won't be ran and won't be included in next year's figure

 

[ExceLoki]

try something like this
--------------------

Book1
	A	B	C	D
1	Vendor	current monthly figures	active?	prediction
2	a	100	active	1300
3	b	100	inactive
Sheet2

Cell Formulas
Range	Formula
D2:D3	D2	=IF(C2="active",B2/4*52,"")

 

[RobA]

Thank you, I suppose this would still work if I put the "active" in a different sheet and if there was 12 months figures rather than 1 month?

So if I put =IF('sheet'C2="active",=sum(B2:B13))

 

[Peter_SSs]

So if I put =IF('sheet'C2="active",=sum(B2:B13))

Yes, except that you wouldn't include that "=" in fron of SUM and you would include whatever should be returned if that cell is not "active", just as @ExceLoki did in post 2

 

[RobA]

Yes, except that you wouldn't include that "=" in fron of SUM and you would include whatever should be returned if that cell is not "active", just as @ExceLoki did in post 2

View attachment 83979

Got this working Thank you

 

[Peter_SSs]

Good news. Thanks for letting us know.