Greater Than or Equal to Formula Help

[Willindallas]

I am doing an IF function and trying to accomplish the following but keep getting an eror messge.

=SUM(G9:G18)/5 >= (SUM(G8:G17)/5+SUM(G7:G16)/5+SUM(G6:G15)/5)*0.79

Any ideas what I'm doing wrong?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[moonfish]

It works just fine if I copy that into excel.

• Is your Excel set to English? A different language can result in a #NAME error.
• Does your installation of Windows use decimal points, or decimal commas? You might have to enter 0,79 instead.
• Does your source data contain errors? #DIV/0 and #NAME can't be summed.

What type of error are you receiving, exactly?

 

[Willindallas]

I just pasted the formula into a cell in a blank spreadsheet and it worked for me as well, returning the value TRUE. My problem is I click on Fx (functions) and select the IF function and the dialog box pops up asking for the logical_test. In that box I enter the formula and it returns an "invalid" response.

 

[Willindallas]

I was able to fix this error by typing the entire IF function directly into the excel cell rather than using the function box to guide me.