Conditional Statement?
I'm trying to create a loop to read elements from column B (the total number
changes all the time) and based on their value, copy and paste different
formulas stored in other cells i.e.(E:81,F:81) to the column next to the
element:
B C D
Li Formula 1
Na 5 Formula 2
Sc Formula 1
Co Formula 3
Ni 3 Formula 2
Cu Formula 1
Mo 2 Formula 2
The elements Li, Sc, Rh, Ho use the same Formula 1, element Kr uses a unique
formula (Formula 2), the elements with numbers in column C use Formula 3 and
finally the rest of elements with empy spaces in C get Formula 4.
Any help will be greatly appreciated!
|