**Please Note: **
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), *this tip may not work for you*. For a version of this tip written specifically for later versions of Excel, click here: Dealing with Long Formulas.

Anyone who has been using Excel for any length of time knows that some formulas can get quite long. Excel handles them—as long as they are constructed correctly—but they can be a bear for humans to understand. Even after you develop your own formulas, you may have trouble understanding them weeks or months later.

One way to make formulas a bit easier to understand is to use **Alt+Enter** in the middle of the formula to "format" how it appears on the screen. Consider, for instance, the following long formula:

=+IF($A2=0,0,IF($B2<4264,0,IF(AND($B2>=4264,$B2<=4895), (-22.31*$C2/365),IF(AND($B2>=4895,$B2<=32760),($B2*0.093- 476.89)*$C2/365,IF($B2>32760,($B2*0.128-1623.49)*$C2/365)))))

This formula could also be written in the following manner, with **Alt+Enter** being pressed at the end of each line in the formula:

=+IF($A1=0,0, IF($B1<4264,0, IF(AND($B1>=4264,$B1<=4895),(-22.31*$C1/365), IF(AND($B1>=4895,$B1<=32760),($B1*0.093-476.89)*$C1/365, IF($B1>32760,($B1*0.128-1623.49)*$C1/365)))))

Now, the broken-up formula appears on five lines, even though it all appears in a single cell. The broken-up formula works just as if it were all on one line.

In addition, if you copy the complete broken-up formula from the Formula bar and paste it into a worksheet, each line in the formula is pasted into a different cell, making it easy to test each part. This is much quicker than copying and pasting parts of the original formula.

*ExcelTips* is your source for cost-effective Microsoft Excel training.
This tip (3043) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: **Dealing with Long Formulas**.

**Create Custom Apps with VBA!** Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out *Mastering VBA for Office 2013* today!

Want to establish a "bottom limit" on what dates can be entered in a cell? This tip presents two different ways you can ...

Discover MoreNeed to enter information into a bunch of cells that aren't anywhere near each other in the worksheet? Here's a handy way ...

Discover MoreWhen processing data, you may have a need to split a long text string into shorter chunks of text consisting of whole ...

Discover More**FREE SERVICE:** Get tips like this every week in *ExcelTips,* a free productivity newsletter. Enter your address and click "Subscribe."

2018-04-11 09:59:07

Raghunath Dhungel

=IF('1stTerm'!G9>='Record '!$O$1,'Record '!$O$2,

IF('1stTerm'!G9>='Record '!$P$1,'Record '!$P$2,

IF('1stTerm'!G9>='Record '!$Q$1,'Record '!$Q$2,

IF('1stTerm'!G9>='Record '!$R$1,'Record '!$R$2,

IF('1stTerm'!G9>='Record '!$S$1,'Record '!$S$2,

IF('1stTerm'!G9>='Record '!$T$1,'Record '!$T$2,

IF('1stTerm'!G9>='Record '!$U$1,'Record '!$U$2,

IF('1stTerm'!G9>='Record '!$V$1,'Record '!$V$2,

IF('1stTerm'!G9>='Record '!$W$1,'Record '!$W$2,'Record '!$X$2))))))))

2018-02-27 13:30:28

Doug Robinson

Mind blown!!

I've been using spreadsheet for 30 years and I never knew that!

Mind blown..

2017-03-14 20:14:15

Rob Long

I'm doing a formula on a serious of date ranges where each date range holds a title. Thus if something is >= <= the date range - the cell result will be the name of of the range.

2016-10-20 07:39:03

sitim

I got a long equation to fit in the excel.I have tried so many times but it never work. Can u pls help me with this?

= EXP[-1.803-0.976(-0.197)+0.976ln(0.560)+2.673ln(20.63)-0.0299[ln(20.63)^2]

Thanks.

Got a version of Excel that uses the
menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)?
**This site is for you!** If you
use a later version of Excel, visit
our *ExcelTips* site focusing on the ribbon interface.

**FREE SERVICE:** Get tips like this every week in *ExcelTips,* a free productivity newsletter. Enter your address and click "Subscribe."

Copyright © 2018 Sharon Parq Associates, Inc.

## Comments