topic Re: Help needed with formula in Building Power Apps
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/318828#M91708
thank youWed, 10 Jul 2019 15:27:15 GMTMartinBlack2019-07-10T15:27:15ZHelp needed with formula
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317872#M91399
<P>Hi all</P><P>PowerApps / Sharepoint beginner here.</P><P>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.</P><P> </P><P>In Sharepoint I've created a list with which I intend to build an app in Power Apps. </P><P> </P><UL><LI>One of the columns in the list is called 'total'</LI><LI>Another column is called 'rating'.</LI><LI>'rating' is a 'calculated' column</LI><LI>In the 'rating' column I want to give a rating (number) that depends on the number in 'total'<BR />For example:<BR />If the 'total' is between 1 and 5 then the rating should be 1<BR />If the 'total' is between 6 and 10 then the rating should be 2<BR />If the 'total' is between 11 and 15 then the rating should be</LI></UL><P>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.</P><P> </P><P>Best wishes</P><P>Martin</P>Tue, 09 Jul 2019 14:18:56 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317872#M91399MartinBlack2019-07-09T14:18:56ZRe: Help needed with formula
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317902#M91407
<P>Try the following in the rating column. Make sure both rating and total are numeric columns</P>
<PRE>=IF(source<6,1,IF(source>10,3,2))</PRE>Tue, 09 Jul 2019 14:32:54 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317902#M91407Pstork12019-07-09T14:32:54ZRe: Help needed with formula
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317923#M91412
<P>Hi <LI-USER uid="72598"></LI-USER> many thanks for the response. That formula works!</P>Tue, 09 Jul 2019 14:48:48 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317923#M91412MartinBlack2019-07-09T14:48:48ZRe: Help needed with formula
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317927#M91415
<P>How does the forumual change if I have four ratings?:</P><P> </P><P>If the 'total' is between 1 and 5 then the rating should be 1<BR />If the 'total' is between 6 and 10 then the rating should be 2<BR />If the 'total' is between 11 and 15 then the rating should be 3</P><P>If the 'total' is between 16 and 20then the rating should be 4</P><P> </P><P>Many thanks</P>Tue, 09 Jul 2019 14:52:51 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/317927#M91415MartinBlack2019-07-09T14:52:51ZRe: Help needed with formula
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/318019#M91467
<P>For that you can expand the pattern of the formula with another If statement like this</P>
<PRE>=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))</PRE>Tue, 09 Jul 2019 16:31:51 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/318019#M91467Pstork12019-07-09T16:31:51ZRe: Help needed with formula
https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/318828#M91708
thank youWed, 10 Jul 2019 15:27:15 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-needed-with-formula/m-p/318828#M91708MartinBlack2019-07-10T15:27:15Z