Forum Discussion
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...
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.
In P2:
=IF(OR(N2:O2=""), "", N2/O2)
Format P2 as a percentage with 0 decimal places.
Thank you, this did solve the blank cells dilemma but returned the value as 1 instead of 100%
As I mentioned: Format P2 as a percentage with 0 decimal places.
