Hi

I have a formula:

=IF($D$12:$G$12="18mm Flat",$E25+22,$E25+45)

Basically if the range of cells D12 to G12 has the text "18mm Flat" in it, then the answer should be the value of the corresponding E cell + 22. When I use the function wizard for this, it tells me that the formula result is 22 (cell E25=0). However, when I actually look at the spreadsheet, the answer shown is 45.

Why is this and how can I correct it?

Could you give a sample row?