cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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 I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

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 I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
Dual Super User III
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 I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

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

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

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 I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

thank you

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,832)