if-statement google-sheets sum division divide-by-zero

How to return a blank field to a cell when a formula is working a number

Probably a really easy solution.

I'm working with a sheet that has a simple division of two numbers to return the difference as a percentage. In this case: =O12/K12

Now if O12 and K12 are empty the cell returns a value of 0.00%. How can I change the formula so it just stays blank if there is no data in O12 and K12 please?

Any help would be amazing!

Thanks Ryan

Solution

try:

=IFERROR(1/(1/(O12/K12)))

Batch: Comparing version numbers via GEQ when said version uses dots and varying number of digits
Is there a way I can reduce this in-a-row kind of repeating Lua conditions?
two if or more with one ELSE
Simplifying If Statements Into Loop
Add 95 to a cell if the name and date in that row match another row with the same name and date
Is there a way to do 24-hour format and 60-minute format in Java?
Using IF in function for different queries as a result
Fat-Free Framework Template Conditional Rendering Issue on Template
Print a multiplication table in Python
Can you store a variable inside a if-clause?
How do I test for exceptions in if-statements in python?
How to write lambda function with three conditions
Matching multiple number rows and check corresponding dates within 90 days
Sum all cells for which corresponding cell is not a formula and doesn't return #VALUE AND date occurs in the past
If condition that matches if grep outputs at least one result even though the exit code is 2 due to some permission denied
Why does `ifelse()` behave differently than `if (cond) {...} else {...}`?
A Return inside and outside an If Statement
How can I use "*ngIf else"?
How to check repeated letters in a string c#
How to create an 'empty if statement' in Python
How to avoid if statement? for the compiler cannot optimize it to simd
Test if it exists a node HXT
python else statement causes a continuous loop
Series of if vs else-if statements benchmarking
Google Sheets - make a list of the names in column A where column E is greater than zero
Condition evaluation process in Java
Excel - Array Formula to skip empty cells
Groups of compound conditions in Bash test
How to use the IF statement to avoid the Weather API fetch result crashing once the user types wrong the city name?
Comparing Text with a lot of If/else