Forum Discussion
Text to numeric
Hi , I am a total excel novice , have been trying to create a timesheet formula where by I could enter text in 1 box and have it allocate a pre set value in another , eg "early " would give a return...
Hello,
Let say you have:
Early in cell A1
Mid in cell A2
Late in cell A3
Or
List Data Validation drop-down in cells A1:A10 (for example)
In output cell, execute the Nested IF Statement below: =IF(A1="early",5,IF(A1="mid",6,8))
Then, copy down the formula
Let say you have:
Early in cell A1
Mid in cell A2
Late in cell A3
Or
List Data Validation drop-down in cells A1:A10 (for example)
In output cell, execute the Nested IF Statement below: =IF(A1="early",5,IF(A1="mid",6,8))
Then, copy down the formula