Update
Only logged in members can reply and interact with the post.
Join SimilarWorlds for FREE »

Looking for a user that is good with Microsoft Excel Spreadsheets

Need to have someone make me a spreadsheet
Top | New | Old
@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.
This message was deleted by its author.
@ShenaniganFoodie

IFS(B6>=B2,((B6-B2)*B3)+B4, B6<B2,((B6-B2)*B3)+B4)
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?
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.

 
Post Comment