T-Bone
In Cryo Sleep
OK, here's the beef. Myself and Social_outcast are in uni and we are doing a project but are struggling to find the correct syntax for a forumla. What we need is
=IF(E3="Yes",L3,HERES WHERE WE NEED THE HELP)
So basically that states that if cell E3 contains the string "Yes" then it equals cell L3's value. What we need however is that when it doesn't equal "Yes", the value will be "No" but that's redundant, we need the cell to take the value of the string "OC" and then the value of the cell K3. So if K3's value were 42 the new cell's value would be OC42.
Any help cracking this problem will be much appreciated.
--T-Bone
=IF(E3="Yes",L3,HERES WHERE WE NEED THE HELP)
So basically that states that if cell E3 contains the string "Yes" then it equals cell L3's value. What we need however is that when it doesn't equal "Yes", the value will be "No" but that's redundant, we need the cell to take the value of the string "OC" and then the value of the cell K3. So if K3's value were 42 the new cell's value would be OC42.
Any help cracking this problem will be much appreciated.
--T-Bone
