Thread: Substituting column values in formulas

I'm not excel savvy at all but I figured out how to input formulas for a spreadsheet I'm making. Column I = F2/8 and the values for I are then used for K =100*(((I2/3.14159)-0.124)/(I2/3.14159)). This works great. But there are times when I need the values of F to be substituted for the values of Column G. There are not values for every row of G, but when there IS a value entered I need the equations to use that value instead of the value from F. I'm on a Mac, have no programming skills, and maybe this isn't possible, but I thought I'd ask!

Perhaps:

=IF(G2<>"",G2,F2)/8