Hi,
Is there a macro so that a specifice calculation is automatically done depending on the letter in a specific cell?
Ie, if i have the letter "B" in cell E8, then the sum in R8 = L8+O8+P8
but if i have the letter "S" in cell E8, then the sum in R8= L8-O8-P8
Ideally this would be applied for the whole column E, so regardless of specific cells, the calculations in column R is according to the letter in the corresponding row/cell
ie, this is also applied to R11, R14 and R22 depending on the letters in E11, E14, E22, but without having to go through and manually input the calculation.
Hope that makes sense!
Any help most appreciated as always.
Best,
MM
Bookmarks