If I have a cell (J1) which is used as a score rating system in which 1 to 6 would mean I need to type LOW in another cell (Q1) or 7 to 14 would mean typing MEDIUM, with 15 to 36 meaning I would need to type HIGH is there a formula I can add to the result cell (Q1) to automatically enter the correct word? I was wondering about IF and the AND statements, but can't see the wood for the trees IYSWIM. Thanks -- -- Robbo 1500GL 1988 Goldwing (Waiting Sale) BMW K100 RS 1984 "Fairly Quick" status. Silver level BotaFOF #19. E.O.S.M 2001/2002/2003/2004. B.O.S.M 2003, 2004 .FURSWB#1 KotL..YTC449 PM#7 ..
Perfick my man! Changed the cell references to suit revised spreadsheet all works great. Have to paste in the correct areas individually as the block "Cut n Paste" wont work. A minor problem really Many thanks -- -- Robbo 1500GL 1988 Goldwing (Waiting Sale) BMW K100 RS 1984 "Fairly Quick" status. Silver level BotaFOF #19. E.O.S.M 2001/2002/2003/2004. B.O.S.M 2003, 2004 .FURSWB#1 KotL..YTC449 PM#7 ..
There's summat wrong in there somewhere. If score is 6 or more and under 36 I get MEDIUM. 15 to 36 inclusive should give HIGH 7 to 14 should give MEDIUM -- -- Robbo 1500GL 1988 Goldwing (Waiting Sale) BMW K100 RS 1984 "Fairly Quick" status. Silver level BotaFOF #19. E.O.S.M 2001/2002/2003/2004. B.O.S.M 2003, 2004 .FURSWB#1 KotL..YTC449 PM#7 ..
It works correctly at my end. Did you type it in or cut-n-paste? I cut-n-pasted it back into Excel, filled a column with numbers from 0 to 42 and it filled the adjacent column with the correct score names.
Spot on John Fekin Risk Assessment spreadsheets are enough hassle without manual entry! -- -- Robbo 1500GL 1988 Goldwing (Waiting Sale) BMW K100 RS 1984 "Fairly Quick" status. Silver level BotaFOF #19. E.O.S.M 2001/2002/2003/2004. B.O.S.M 2003, 2004 .FURSWB#1 KotL..YTC449 PM#7 ..
