Posted to microsoft.public.excel.misc

George

external usenet poster

Posts: 347

Shorten Formula

Excel 2009
Is there any way I can shorten this formula?
=IF(OR(D3="6A",D3="3G",D3="4G",D3="5G",D3="6G",D3= "6L",D3="SS",D3="3T",D3="4T",D3="5T",D3="6T",D3="N IL"),"",IF(D3="3A",C3*E2,"Not
equal to 6A or 3G or 4G or 5G or 6G or 6L or SS or 3T or 4T or 5T or 6T or
NIL"))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shorten a formula	Jeze77	Excel Discussion (Misc queries)	0	August 30th 07 07:46 PM
Shorten a formula	Jeze77	Excel Discussion (Misc queries)	6	August 30th 07 06:34 PM
Shorten Formula	Lemmesee	Excel Worksheet Functions	3	January 7th 07 10:30 PM
Shorten an IF formula	Joker	Excel Discussion (Misc queries)	4	December 10th 05 12:30 PM
shorten formula	PACable	Excel Worksheet Functions	8	October 27th 05 12:39 AM

All times are GMT +1. The time now is 01:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us