Previous Topic Next Topic

Calculate a percentage when the values are text

Closed
Duwop01 Posts 1 Registration date Thursday October 19, 2017 Status Member Last seen October 19, 2017 - Oct 19, 2017 at 04:45 PM
 Blocked Profile - Oct 19, 2017 at 04:49 PM
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 response

Answer 1 / 1
Blocked Profile
Oct 19, 2017 at 04:49 PM
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!



Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
peterappiahkubi -
Wofanat -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses