Forum Discussion

Copper Contributor

Dec 01, 2024

Solved

Help with Excel formula

Hello, I am a complete Noob, apologies for everything! I am making a reading tracker in Excel and would like to learn how to create a formula to find the percentage of read pages vs total pages. I h...

excel

Formulas and Functions

NikolinoDE
Dec 01, 2024
You're off to a great start with your formula!
Here's how to modify it step by step to achieve your desired results:

=IF(OR(N2="", O2=""), "", IF(N2=O2, "100%", TEXT(N2/O2, "0%")))

Copy the formula above.
Paste it into cell P2.
Ensure that your N2 (read pages) and O2 (total pages) cells have numeric values or are left empty.

NikolinoDE

Platinum Contributor

Dec 01, 2024

You're off to a great start with your formula!

Here's how to modify it step by step to achieve your desired results:

=IF(OR(N2="", O2=""), "", IF(N2=O2, "100%", TEXT(N2/O2, "0%")))

Copy the formula above.

Paste it into cell P2.

Ensure that your N2 (read pages) and O2 (total pages) cells have numeric values or are left empty.

noobneedshelp

Copper Contributor

Dec 01, 2024

Thank you, you are a legend! Works perfectly!

I don't suppose you would have the answer to an audiobook version would you? Q2 is hours listened, R2 is total time, S2 would be 100%. There would be hours and minutes e.g. 7:05, 7:05, 100%