Hello Everyone! Long time reader, first time poster. I am having trouble with an IF formula. Can someone help me write this formula correctly:
IF formula help.jpg
I want the total from column L (or M depending on the the project type, so L for site but M for others) to show up in either columns D, E, F, G, or H depending on on column C. If column C says A I want the total from L to show up in column D. If C says B, total from L should be in column E and so on. The idea would be to move that row to a different priority column but changing column c's input.
I tried a few If formulas but I cannot get this to work.
Any advice or direction?
Thanks to all!
Bookmarks