| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shorter formula / not array?: every other col..
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)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a contingent formula shorter... | Excel Discussion (Misc queries) | |||
| Formula too long - Shorter version? | Excel Worksheet Functions | |||
| 2nd attempt ~ Faster/Shorter formula | Excel Worksheet Functions | |||
| Need faster/shorter formula | Excel Worksheet Functions | |||
| Shorter Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
