Spreadsheet

[TJ]

I am trying to make a spreadsheet, where the following
occurs.

A numerical value is entered in cells C1, F1, I1, L1, O1,
R1, and U1. The total is entered in X1, but the value in
X1 must be a maximum value of 40, and if X1 is greater
than 40 the remaining value is automatically entered in
Y1. If the value in X1 is 40 or less, zero will be placed
in Y1.

Cell Y1 cannot be a negative number.

I hope that someone will be able to help me.

Thanks in advance

TJ

 

[Jordon]

I am trying to make a spreadsheet, where the following
occurs.

A numerical value is entered in cells C1, F1, I1, L1, O1,
R1, and U1. The total is entered in X1, but the value in
X1 must be a maximum value of 40, and if X1 is greater
than 40 the remaining value is automatically entered in
Y1. If the value in X1 is 40 or less, zero will be placed
in Y1.

Cell Y1 cannot be a negative number.

Easy,

X1 =
=IF(C1+F1+I1+L1+O1+R1+U1>40,40,C1+F1+I1+L1+O1+R1+U1)

Y1 =
=IF(X1=40,C1+F1+I1+L1+O1+R1+U1-40,0)

 

[Sandy Mann]

Easy,

X1 =
=IF(C1+F1+I1+L1+O1+R1+U1>40,40,C1+F1+I1+L1+O1+R1+U1)

Y1 =
=IF(X1=40,C1+F1+I1+L1+O1+R1+U1-40,0)

Sightly shorted but not better........

Y1=
=MIN(C1+F1+I1+L1+O1+R1+U1,40)

X1=
=MAX(C1+F1+I1+L1+O1+R1+U1-40,0)

Sandy

 

[Jordon]

"Jordon" wrote

Sightly shorted but not better........

Y1=
=MIN(C1+F1+I1+L1+O1+R1+U1,40)

X1=
=MAX(C1+F1+I1+L1+O1+R1+U1-40,0)

I'm the King of doing it the hard way.

Jordon