cancel
Showing results for
Did you mean: Frequent Visitor

Help needed with formula

Hi all

PowerApps / Sharepoint beginner here.

I realise this is a PowerApps forum but I'm unable to move forward to PowerApps without resolving this issue with SP, so I'm hoping someone can help.

In Sharepoint I've created a list with which I intend to build an app in Power Apps.

• One of the columns in the list is called 'total'
• Another column is called 'rating'.
• 'rating' is a 'calculated' column
• In the 'rating' column I want to give a rating (number) that depends on the number in 'total'
For example:
If the 'total' is between 1 and 5 then the rating should be 1
If the 'total' is between 6 and 10 then the rating should be 2
If the 'total' is between 11 and 15 then the rating should be

I've been trying out different formulas with no success and am hoping someone here can help.  I can't move on to PowerApps until I sort this, I'm pretty sure the answer is simple but at present it is beyond me.

Best wishes

Martin

2 ACCEPTED SOLUTIONS

Accepted Solutions  Dual Super User III

Try the following in the rating column.  Make sure both rating and total are numeric columns

=IF(source<6,1,IF(source>10,3,2))

-------------------------------------------------------------------------
If you like my response, please give it a Thumbs Up.  Dual Super User III

For that you can expand the pattern of the formula with another If statement like this

=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))

-------------------------------------------------------------------------
If you like my response, please give it a Thumbs Up.
5 REPLIES 5  Dual Super User III

Try the following in the rating column.  Make sure both rating and total are numeric columns

=IF(source<6,1,IF(source>10,3,2))

-------------------------------------------------------------------------
If you like my response, please give it a Thumbs Up. Frequent Visitor

Hi @Pstork1 many thanks for the response.  That formula works! Frequent Visitor

How does the forumual change if I have four ratings?:

If the 'total' is between 1 and 5 then the rating should be 1
If the 'total' is between 6 and 10 then the rating should be 2
If the 'total' is between 11 and 15 then the rating should be 3

If the 'total' is between 16 and 20then the rating should be 4

Many thanks  Dual Super User III

For that you can expand the pattern of the formula with another If statement like this

=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))

-------------------------------------------------------------------------   