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%

Calculate a percentage when the values are text
How to calculate 90 days from date in excel - Guide
How to calculate position in excel ✓ - Excel Forum
How to calculate aggregate percentage - Excel Forum
Formulas for 1st and 2nd position in class - Office Software Forum
How to calculate vat - Guide

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

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

help me to add particular cells

Percentage calculation

calculating fuel surcharge

How to calculate position (1st,2nd,3rd) in excel....?

Similar discussions

Subscribe To Our Newsletter!