I can't believe I have never found this forum before!
Anyway, wondering if someone could help with probably something very simple. Have a column in Excel 2007 which is a few thousand rows long and is populated randomly with the numbers 24, 36 & 48. I'd like to use this data in another column and produce a result depending on what is found. I'm trying this formula:
=IF(M7=24,R7*26/29+5)*OR(M7=36,R7*38/42+5)*OR(M7=48,R7*50/53+5)
I think I'm nearly there (or am I!) - what am I doing wrong as the 24 calc works and I get 0.00 result for the 36 & 48 calc?
Cheers
Mike
Bookmarks