New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Shrink this formula?

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Shrink this formula?

Postby terynmerc » Wed Apr 13, 2016 10:21 am

Hi All, I'm use to creating formulas in 2016 and they often become very long. I'm trying to make my sheet compatible with 2003 but I can't figure out how to shrink this formula. Any have any ideas?

Formula works fine though, just trying reduce its size somehow.

Code: Select all
=IFERROR(IF(AV23="Net Price",IFERROR(SUBSTITUTE(IF(BOOKSELECT="MSRP",IF(AU23="MSRP",SUBSTITUTE(AU23,"MSRP",DISCNAME),AU23),IF(BOOKSELECT="A & D",AU23,IF(BOOKSELECT="B. Discount",AV23,IF(BOOKSELECT="Product Discount",AV23,IF(BOOKSELECT="Book Discount",IF(DISCSELE="Net Price",AU23,AV23),AU23))))),"Net Price",NETREPLACE),AU23),VALUE(IFERROR(SUBSTITUTE(IF(BOOKSELECT="MSRP",IF(AU23="MSRP",SUBSTITUTE(AU23,"MSRP",DISCNAME),AU23),IF(BOOKSELECT="A & D",AU23,IF(BOOKSELECT="B. Discount",AV23,IF(BOOKSELECT="Product Discount",AV23,IF(BOOKSELECT="Book Discount",IF(DISCSELE="Net Price",AU23,AV23),AU23))))),"Net Price",NETREPLACE),AU23))),AU23)
  • 0

terynmerc
Rookie
 
Posts: 1
Joined: Apr 13, 2016
Reputation: 0
Excel Version: 2016

Re: Shrink this formula?

Postby CBombea » Tue May 17, 2016 12:07 pm

Hi,

IFERROR is not recognized by Excel 2003. Also to many IF for 2003...
Attach file with no sensitive data and we try to change/reduce your formula.
  • 0

CBombea
Rookie
 
Posts: 1
Joined: May 17, 2016
Reputation: 0
Excel Version: 2013


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 37 guests