Need help with Excel formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle Udell - 18 Nov 2005 07:03 GMT

I need some help understanding some formulas that already exist on a workbook
that someone else made. Here is an example of one:

=IF(AND('Past Due Report' !E4>0, 'Past Due Report' !E4<16), 'Past Due
Report' !G4,0)

'Past Due Report' is the name of sheet 1 in the workbook, and the formulas
exist on sheet 3. What does the exclamation point mean?

I hope I explained my question clearly... thanks to whoever helps me!

Reply to this Message

Anne Troy - 18 Nov 2005 07:10 GMT

Hi, Michelle. The exclamation point is just a "break" that Excel uses to
differentiate between a sheet name and a cell reference. What the formula
means, in english, is if E4 is greater than zero AND E4 is less than 16 (so
somewhere between those two numbers), then return cell G4 (E4 and G4 being
from sheet1). The last part, which is the "comma zero" part, says that if
either of those two IFs are not true, return zero.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

>I need some help understanding some formulas that already exist on a
>workbook
[quoted text clipped - 7 lines]
>
> I hope I explained my question clearly... thanks to whoever helps me!

Reply to this Message

Bob Phillips - 18 Nov 2005 08:39 GMT

Also, note that the sheet name has single quotes around it, as it has
embedded spaces. Sometimes, if the sheet name is just a continuous string,
they are omitted.

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> Hi, Michelle. The exclamation point is just a "break" that Excel uses to
> differentiate between a sheet name and a cell reference. What the formula
[quoted text clipped - 18 lines]
> >
> > I hope I explained my question clearly... thanks to whoever helps me!

Reply to this Message