I need to have the following statement return my square footage two ways...total square footage and total square footage divided by two.
My formula will return correctly if i choose the DH890_1 but it will not give me the half amount if I choose the SL870_1?
Any ideas?
=IF(C7={"DH890_1","SL870_1"},(E7*F7/144)/2,(E7*F7)/144)
Bookmarks