RPM, the first formula looks ok structurally, but you are treating your numbers as strings (text), which might cause issues. Try this:
[code] =IF(C2=1,G12,IF(C2=2,G14,IF(C2=3,G17,IF(C2= 4,G19,IF(C2=5,G22,IF(C2=6,G24,IF(C2="sm",G26, ""))))))) [/code]
Basically "2" is not the same as 2.
EDIT: Tiswas got there before me.
@mattty started 14 years ago
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
RPM, the first formula looks ok structurally, but you are treating your numbers as strings (text), which might cause issues. Try this:
[code]
=IF(C2=1,G12,IF(C2=2,G14,IF(C2=3,G17,IF(C2= 4,G19,IF(C2=5,G22,IF(C2=6,G24,IF(C2="sm",G26, "")))))))
[/code]
Basically "2" is not the same as 2.
EDIT: Tiswas got there before me.