I have attached a spreadsheet where I am having difficulty counting the number of cells that =10% and =0% (they are highlighted in red). The rest of my formulas appear to be working properly. Can someone tell me what I am doing wrong with the formula in C8 & C9? There is a lot of data to try to count (about 18116 data points in one column) and I want to be able to use this for future data.
Thanks, dcoates
Because, even though you are only showing the values in Column D to whole percentage points, the actual number is different (i.e. 10.2% shows as 10%). Incorporate the ROUND function into D
In D16
=IF($B16="","",IF($B16<=0,"error",ROUND((ABS($B16-$C16))/(($B16+$C16)/2),2)))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
it is because you have no data actually equal to 10% or 0%
add a round formula to column D data and round to 2 places.
EDIT: chemist beat me
Last edited by dosydos; 03-10-2016 at 01:30 PM.
I did not think about using the round function. Thanks that worked. Awesome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks