Hello all,
IS there any chance i could combine these two formulas, into one?
=IF(AND(A5="E1";L5="CURS 1");ROUND(T10*C19;2);ROUND(T10*C21;2))
IF(AND(A5="E100";L5="CURS 1");ROUND(T7*C19;2);ROUND(T7*C21;2))
I tried something like this, but i get a #VALUE error:
=IF(AND(A5="E1";L5="CURS 1");ROUND(T10*C19;2);ROUND(T10*C21;2));IF(AND(A5="E100";L5="CURS 1");ROUND(T7*C19;2);ROUND(T7*C21;2))
Thank you!
Bookmarks