Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do i create a function to give me the following mathematical formula:
(a+b+c+d+e+f)/N * 6/N Where a-f are numbers between 0-9 inclusive and importantly N = 6 - (the number of values a-f that are '0') example numbers = 1 3 5 7 0 8 Then N= 5 So answer is 24/5 *6/5 = 5.76 Thanks Simon -- simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help in EXCEL functions - needed badly | New Users to Excel | |||
Need help badly | Excel Discussion (Misc queries) | |||
Need Help Badly! | Excel Worksheet Functions | |||
VBA coding needed badly | New Users to Excel | |||
Badly need help to put four categories in one pie chart | Charts and Charting in Excel |