# Theory Question

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Because in order to figure the percentage of days to total days, you divid days by total days. This would give you the % of days missed,
To flip it to show the % of days not missed, you subtract from 1.

The division (B2/\$A\$2) yields a decimal less than 1 (the \$ signs keep the second reference on A2 instead of dragging it down thru the column). So 1 minus this decimal yields another decimal less than 1. For instance if the days absent are 7, the formula alone yields 0.3333333333. One minus this is 0.6666666666, and formatted as a percentage it's 66.666666...or 66.67 as you show. Basically if you entered the number of days attended, instead of the days absent, you could take out the "1-", because the percentage you want is the days they WERE there, the "1-" just inverts it from days missed to days present.

EDIT: late again...lol, oh well now you have 2 answers.

The formula shows the percentage of days Not Absent. A percentage is the ratio of something compared to 100. Formatting a number in Excel as a percent will cause the actual result of the formula to be multiplied by 100 and displayed with the % symbol.

In this case the 1 (when multiplied by 100) represents the 100% attendance that would result if there were no days of absence. The remainder of the formula -(B2/\$A\$2) represents the portion of time absent. 0/21 = 0. 0x100 = 0. 100-0=100.

Is this what you were interested in?

Hi Stephen
Column B shows the absent days but column C shows the attendance percentage. B2/A2 gives a value less than 1 which you have deducted from 1 in column C. If you remove the format percentage from column C it will show values between 0 and 1, inclusive. As KleptoOne stated, you have effectively condensed a number of calculations into a single formula. Try using -1 or 22 in column B to see the effect on column C.
HTH, Andrew.

Thanks everyone for the help!!!

Stephen

Replies
7
Views
299
Replies
5
Views
228
Replies
4
Views
68
Replies
15
Views
231
Replies
12
Views
158

Threads
1,203,675
Messages
6,056,683
Members
444,882
Latest member
cboyce44

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back