Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement help
I want to average a group of numbers. I am using 1-5. If the average
exceeds 5.0 I want the value to return 5.0 if not then I just want the average of the group of numbers. I wrote the following and the formula works if true but returns a "false" if false. =If(average(g9:g19)5.0,5.0,Average(g9:g19) I know the above is incorrect. The formula works on the first part but if false if multiplies the second average. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement help
You don't really need an IF Statement for this. I think the MIN() function
will work for you. =MIN(AVERAGE(G9:G19),5.0) This returns the lowest (minimum) value between 5 and the average of your range. HTH, Elkar "lschuh" wrote: I want to average a group of numbers. I am using 1-5. If the average exceeds 5.0 I want the value to return 5.0 if not then I just want the average of the group of numbers. I wrote the following and the formula works if true but returns a "false" if false. =If(average(g9:g19)5.0,5.0,Average(g9:g19) I know the above is incorrect. The formula works on the first part but if false if multiplies the second average. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If Statement? | Excel Discussion (Misc queries) | |||
IF Statement problem | New Users to Excel | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |