Formula to divide a number and format if greater than a 100

[Shellybelly]

I need a formula that will divide a number and if the answer is greater than a 100 then blank.

i've been using this =IFERROR(SUM(H4/C4,"",IF(K4>100,""))) but no luck.

Help!!!!

[6StringJazzer]

What result do you want if the result of the division is <=100?

What is in K4?

Your use of SUM is not correct--you have three arguments and only one is a number. I can't tell what you're trying to do there.

Maybe you want:

Please Login or Register  to view this content.

[Moo the Dog]

I am assuming you want to test if H4/C4 is > 100:

=IF(H4/C4>100,"",H4/C4)

- Moo

[Olly]

Try:

Please Login or Register  to view this content.

[bebo021999]

The formula say nothing to me!
C4/H4 + " " + " " = WHAT?
What is the number that you like to divide?
If you want to compare C4/H4 with 100 then make a logical result for condition format, try like this:
=H4/C4>100
Put this in criteria box of Condition Format and format with black colour

[Shellybelly]

Thanks Bros It works perfectly fine....Thanks soo much.

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.