HOW TO MAKE IF STATMENTS INTO ARRAYS

[GoonSqd]

hey there, im trying to change a co-workers if statements into an array if possible
im trying to validate that If Colum AA is 1 or greater then to check if Colum AQ is between 7.3 and 8.3 and if its anything else to check Colum y and if there is a date then colum AQ should be zero, if there isnt then check colum x and make that the value for colum AQ

 

[GoonSqd]

Okay I'm starting to understand. Please fill in the questions. In column Y what are you supposed to do with a date? Is this a date the price increase is to take effect or end? How do you want that reflected in the calculation?

Book1
	A	B	C	D	E	F
3
4	Conditions		Increase Date?	Price Cap?		Result
5	Col AA	Col AQ	Col Y	Col X		In What cell?
6	1	> 7.3 & < 8.3	End of Conditions calculate now			What value to see?
7	1	NOT(> 7.3 & < 8.3)	Has a date?	End of Conditions calculate now		What value to see?
8	1	NOT(> 7.3 & < 8.3)	Has a date?	Cap amount	End of Conditions calculate now	What value to see?
9	0	End of Conditions calculate now				What value to see?
10
Sheet1

my coworker ended up coming up with this Idk if this will work best of if there's a better solution

 

[awoohaw]

It looks like he was provided with more information than what was given here.

I'm happy he got it working for you.

 

[awoohaw]

This thread continues here:

Trying to combine or shorten IF formulas in order to reduce file size

www.mrexcel.com