I am creating a basic spreadsheet and I would like to create a drop down field with 3 choices (12,6, or 4)in say C1. Then depending on the selection, in two rows across if the selection was 12 then in E1 -4.18 would automatically be linked, 6 would produce -1.08 and 4 would produce -.47. Can anyone help me PLEASE! Thanks
Shane
Bookmarks