Excel help with IF, AND Statements

[MsplcdYkee69]

I am having to check user input in two different cells. Example Code below:

IF(P8="","",IF(AND($C$12=25;P8<($C$22-Y5)),(P8+25),IF(AND($C$12=50;P8<($C$22-Y5)),(P8+50),IF(AND($C$12=75;P8<($C$22-Y5)),(P8+75),IF(AND($C$12=100;P8<($C$22-Y5)),(P8+100),$C$22)))))

P8 = The previous cell to see if it has a value
C12 = User defined input of either= 25, 50, 75, or 100
C22 is a tabulated value and I do not want to exceed this value.

Example:
P7 = 813.65
P8 = Rounds P7 to next User defined integer of ( 25, 50, 75, or 100)
P9 = (Cell the code listed above references) This cell needs to round

P7 = 813.65
P8 = 825.00
P9 = 850.00
P10 = 900.00
P11 = 925.00
P12 = 948.25 (Value in C22)

What I am doing is coming up with Station Values for roadway design.

Any help would be appreciated...

 

[MsplcdYkee69]

Sorry I forgot to mention I am using Excel 2010

Y5 = the difference of C22 minus the last whole number
Y5 = 48.25

 

[jbeaucaire]

Put this formula in P8 and copy down:

Excel Workbook
	C	D	P
7			813.65
8			825.00
9			850.00
10			875.00
11			900.00
12	25		925.00
13			948.25
14
22	948.25
Sheet1

 

[MsplcdYkee69]

Thanks for the help that did the trick...

I just had to tweak it to fit into my formula and add 2 IF statements... I appreciate it a lot...

=IF(N8="","",IF(N8<$C$22,(MIN($C$22, CEILING(N8+0.01,$C$12))),""))


thanks again

 

[jbeaucaire]

I don't think you needed the second IF addition, the MIN(CEILING()) function did that already.