IF Statement

[Softkey]

Hello,

I have a question, I want to use an IF statement and I get an error
can anyone have a look at the workbook and give me any sugestions. Th
formula is in G26

Thank you

www.canadianbyte.com/excel/time_sheet1.xl

 

[Andy B]

Hi

You are addressing more than one cell, so you need to enter the formula as
an array. This is done by hitting Ctrl Shift Enter, instead of just Enter.
After editing the cell (F2), or entering the formula, you need to hold Ctrl
and Shift and then press Enter.

Andy.