I need help writing an if/then statement.
A certain row, for example, let’s use row 3, will have a "C" in it, which will move from month to month, but will never be in the same column twice.
Ultimately, this is what I want the formula to calculate. Let's use K5 as the cell where I would be entering this formula. Detect the cell in L3:AF3 which equal "C" then multiple that cell in row 5 by G5. (For example, if "C" was in Q3, the K5=Q5*G5). How would this formula/if--then statement be written?
Thanks for the help!
Bookmarks