Solved I need to rewright this funtion so that it wosks right.

July 16, 2013 at 18:17:10
Specs: Windows 8
I need to wright this function in a Excel spreadsheet , Everything seems right but it's saying I need to add another parenthesis =IF(OR([Job Status]="CN",[Pay Grade]=4,"Not Eligible" ,0))
How am I righting it wrong.

See More: I need to rewright this funtion so that it wosks right.

Report •

#1
July 16, 2013 at 18:40:58
✔ Best Answer
You need to close the parenthesis for the OR function and eliminate the extra one at the end:

=IF(OR([Job Status]="CN",[Pay Grade]=4),"Not Eligible" ,0)

That said, I'm not familiar with a syntax that uses [Job Status] as a name(?). Can you enlighten me?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
Report •

#3
July 16, 2013 at 19:42:29
Ahh...the key was in this paragraph:

"The general rule to follow is this: If you are using structured references within a table, such as when you create a calculated column, you can use an unqualified structured reference, but if you use the structured reference outside of the table, you need to use a fully qualified structured reference."

i.e. No table name needed if the formula is within the table.

Thanks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question