Replace symbols with numbers

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
If you format your cells as Custom

0.0;-0.0;-

then zeros will be displayed as - but the averages will calculate correctly.

If you use , as the decimal separator then I think you would need

0,0;-0,0;-
 

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,454
You're going to have to use:

=AVERAGE(IF(A1:A10,A1:A10)) << Entered with Ctrl+Shift+Enter Keys. Not just the Enter Key (Yhe formula bar will display the results as:
{=AVERAGE(IF(A1:A10,A1:A10))} You cannot enter the { }'s using the keyboard.

Formatting isn't going the change/alter the actual result value of the cell formula
 

Forum statistics

Threads
1,082,478
Messages
5,365,783
Members
400,850
Latest member
Raj_Jpr

Some videos you may like

This Week's Hot Topics

Top