cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartinBlack
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
Pstork1
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

Pstork1
Dual Super User III
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 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
Pstork1
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

Pstork1
Dual Super User III
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 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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (978)