Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

set up sum with exceptions in numbers

I am creating a chart and need a simple answer. In one column I am entering a number 1-10 and in the 'sum column' I need that number to be multiplied by 57. So that part is easy obviously.


However, if the number is a 5, I need the "sum" to say 260 and if it is 10, I need it to say 500.


Help please!

Posted on Mar 30, 2023 10:06 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 30, 2023 10:57 AM

The IFS function can do the requested job:


Enter the formula shown in the selected cell, changing B2 to the address of the cell containing the 1..10 value.


I've filled the formula down column D to show results for each of the values 1-10 in column B.


You can learn more about the IFS function by entering = in any empty cell. This will open the formula editor, and, in the right sidebar, the Function Browser. Type IFS in the browser's search box, then click the 'IFS' result for a description of the function and an example of its use in a formula.


Regards,

Barry


Each comparison is tested in turn. The first to return the Boolean value 'true'

2 replies
Sort By: 
Question marked as Top-ranking reply

Mar 30, 2023 10:57 AM in response to schoolhousebkprt

The IFS function can do the requested job:


Enter the formula shown in the selected cell, changing B2 to the address of the cell containing the 1..10 value.


I've filled the formula down column D to show results for each of the values 1-10 in column B.


You can learn more about the IFS function by entering = in any empty cell. This will open the formula editor, and, in the right sidebar, the Function Browser. Type IFS in the browser's search box, then click the 'IFS' result for a description of the function and an example of its use in a formula.


Regards,

Barry


Each comparison is tested in turn. The first to return the Boolean value 'true'

Reply

set up sum with exceptions in numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.