Hey all -
So i am looking at a model that has the following formula:
{=MAX(0,SUM(E$70:E$76*TRANSPOSE($E84:$K84))-MAX(0,N119-E$66))}
I have a cell that is a toggle in C43 that I want to do a basic IF function with. So I want the formula to read like this =IF($c$43=1,(MAX(0,SUM(E$70:E$76*TRANSPOSE($E84:$K84))-MAX(0,N119-E$66))),0)
Unfortunately bc of the transpose function I need the { things (i don't even know what they are called) and can't do the combine function with them.
Any assistance is greatly appreciated as usual.
Thanks.
Dan
So i am looking at a model that has the following formula:
{=MAX(0,SUM(E$70:E$76*TRANSPOSE($E84:$K84))-MAX(0,N119-E$66))}
I have a cell that is a toggle in C43 that I want to do a basic IF function with. So I want the formula to read like this =IF($c$43=1,(MAX(0,SUM(E$70:E$76*TRANSPOSE($E84:$K84))-MAX(0,N119-E$66))),0)
Unfortunately bc of the transpose function I need the { things (i don't even know what they are called) and can't do the combine function with them.
Any assistance is greatly appreciated as usual.
Thanks.
Dan