Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Pass or Fail Based on Total

Hello,

I am calculating a percentage:

=Num([Actual Load Percentage]/100,'0%')

Which gives me 54%, now based on that I want to add a column showing PASS or FAIL. So if the percentage is over 30% it passes and if it's under 30% it Fails. I've tried a few ways and it doesn't seem to be working. 

Anyone have any suggestions?

Thank you!

10 Replies
hammermill21
Creator III
Creator III
Author

Thank you Sunny