Forum Discussion
njackson1615
Jan 10, 2024Copper Contributor
Looking for a formula for percentage
Looking for a formula to get the percentage for this situation. Any ideas?
njackson1615
Jan 10, 2024Copper Contributor
Can you give more descriptive instructions?! Newbie to formulas here lol!
HansVogelaar
Jan 10, 2024MVP
Your screenshot does not show the row numbers and column letters.
Which cell contains the number 1254 (Base Capacity for Belmont Ridge MS), for example?
- njackson1615Jan 10, 2024Copper Contributor
- njackson1615Jan 10, 2024Copper Contributor
the items in column d2 are empty by the way those where from last years numbers
- HansVogelaarJan 10, 2024MVP
Select cell D2.
Type =C2/B2
Press Tab or Enter to confirm the formula.
Select D2 again.
Double-click the fill handle, that is the little square in the lower right corner of the selected cell.
This will propagate the formula to the cells below.