Help needed with formula

[MartinBlack]

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

[Pstork1 · Accepted solution]

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))

[MartinBlack]

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

[MartinBlack]

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

[Pstork1 · Accepted solution]

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))

[MartinBlack]

thank you