Hello, yes i know that the IF statement is simple, yet allow me to ask; what kind of error am I generating here, and what is the fix? I get a #NAME? and to me the equation is correct, and my cell format is correct.
This IF statement will get a little more completed. Believe me or not, but i came up with this IF statement;
On Peak'!E2:AA2)+'Off On Peak'!AB1),(SUM('Off On Peak'!L1:AA1))))
Am I bragging, yes I am. I worked hard to get it to work! And now I can't see the problem with this one.