Forum Discussion
Need to tag multiple rows the same, however attributes differ except for ID (nested IF?)
I have a https://1drv.ms/x/s!AhYM9SkP8EZg2CK_jrzDb5AkWBxe?e=tYRb2P of project lines where multiple lines in the file may constitute a single project (col H has consistent budget ID) and that project ...
I believe I can get there with a nested IF and that's the approach I'm currently working on personally, but would be great to hear other ideas.
I'm not following the combination of conditions well enough to give you the final formula -- just a little too confusing for an outsider -- but I think rather than the nested IF approach, it sounds to me as if you should consider something along the lines of
=IF(AND(Cond1,Cond2),Consequence,Else)