Calculate a percentage when the values are text [Closed]

Report
Posts
1
Registration date
Thursday October 19, 2017
Status
Member
Last seen
October 19, 2017
-
 Blocked Profile -
I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. But the values are text.

J1 bill
J2 bob
J3 Tom
...
J14 carol
...
J20 Chris
J21-142%

1 reply


The syntax of the formula for IF is as follows:

=IF(logic_test, true, false).

I am not certain how TEXT (STRINGS), is to be calculated, as your example says that j1-20 needs to be calculated, but they are names (J1=bill).

NAN!



Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!