Can anyone get this attached formula to work on excel??
Thanks
Dave E
Last edited by deastham2000; 02-14-2012 at 03:14 PM.
I have created a formula based on your calc, Including a table for inputting the data variables. However, I am unclear on what the "max" part of the formula is supposed to do? "max" is normally used to find the largest number in a list of numbers, that formula you gave results in just 1 number. If it is part of a list of different answers, then the "max" part, needs to be applied seperately. Hope this helps?
Please
[1] Use code tags. Place "[ code ]" before the first line of code and "[/code]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
[3] Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Thanks I already set the number to 0 decimal places which i think does the same thing? I wasnt sure of the Max either. The formula was
taken from a patent for calculating weightwatchers points.
I think that you missed dividing by the 175 in your formula. Try this one.
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
oops sorry,yes i did, thanks for catching that Alan
Please
[1] Use code tags. Place "[ code ]" before the first line of code and "[/code]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
[3] Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks