LinkBack URL
About LinkBacks
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!!!!
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!!!!
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:
Formula:
=IF(H4/C4>100,"",H4/C4)
I am assuming you want to test if H4/C4 is > 100:
=IF(H4/C4>100,"",H4/C4)
- Moo
Try:
Formula:=IF(H4/C4>100,"",H4/C4)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
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
Quang PT
Thanks Bros It works perfectly fine....Thanks soo much.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks