shorter formula / not array?: every other col..
try:
=IF(OR(E4<"",AE4=""),"",(IF(AF4="",AB4*AE4,SUMPRO DUCT(--(MOD(COLUMN($AE4:$AW4),2)=1),$AE4:$AW4,$AF4:$AX4))-AC4))
"nastech" wrote:
hi, don't know if easier way to setup a formula for saving space & making
more dynamic for adding / deleting columns, but have formula using sets of 2
colums in an equation for price and quantity. doing by hand makes a long -
unwieldy equation. is there a formula or method to overcome? thanks
example using is:
=IF(OR(E4<"",AE4=""),"",(IF(AF4="",AB4*AE4,(AE4*A F4)+(AG4*AH4)+(AI4*AJ4)+(AK4*AL4)+(AM4*AN4)+(AO4*A P4)+(AQ4*AR4)+(AS4*AT4)+(AU4*AV4)+(AW4*AX4))-AC4))
|