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.
As variant
=IFERROR( (N2/N2) * (N2/O2), 1 )