Thread
:
any suggestions?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Dave O
Posts: n/a
any suggestions?
The problem is the plus sign- AVERAGE requires that the arguments are
separated by a comma. Try this:
=(AVERAGE(IF(ISNUMBER(G20),G20),(IF(ISNUMBER(M20), M20))))
....and you'll get the desired results.
Reply With Quote