tonialta · F
For what
View 4 more replies »
@ShenaniganFoodie But what cell is the new score being typed in on? And is this just one, or multiple people?
"X?"= the cell number of "Any score"
Any which Excel do you have? I mainly want to make sure it has the IFS function (with the S).
IFS(X?>=B2,((X?-B2)*B3)+B4, X?<B2,((X?-B2)*B3)+B4)
The formula above would go into B6 as I understand your layout. Though a picture might be more helpful if I'm not understanding correctly.
I hope I understood you correctly, and you understand what I mean by the "X?" being the cell number of whatever the new Any score is.
"X?"= the cell number of "Any score"
Any which Excel do you have? I mainly want to make sure it has the IFS function (with the S).
IFS(X?>=B2,((X?-B2)*B3)+B4, X?<B2,((X?-B2)*B3)+B4)
The formula above would go into B6 as I understand your layout. Though a picture might be more helpful if I'm not understanding correctly.
I hope I understood you correctly, and you understand what I mean by the "X?" being the cell number of whatever the new Any score is.
This message was deleted by its author.
I might help, but you just reported me for no reason... just because you didn't understand.
I didn't need Nuno...
Now what about Excel?
I didn't need Nuno...
Now what about Excel?
ArishMell · 70-79, M
It may help if you can say what you want to calculate, in normal algebraic form; the types of input values, output formats, etc.