[SOLVED] I have to add three columns and if the % is less than 70 I need the cell to show F (for fail) if over 70% then show the number
[SOLVED] I have to add three columns and if the % is less than 70 I need the cell to show F (for fail) if over 70% then show the number
Last edited by jklangenberg; 09-27-2017 at 12:52 PM.
is it the total of three different cells in the same row or is it the total of three whole columns?
if the first, something like =if(sum(A2:C2)<.7,"Fail","Pass")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I'm assuming the three column ranges all contain percentage values.
Then something like
Formula:Please Login or Register to view this content.
Or perhaps easier to have a check cell which sums the % ranges you're interested in and then
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Richard Buttrey - This is perfect, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks