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!



0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

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

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses