LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michelle Udell
 
Posts: n/a
Default Need help with Excel formulas

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' !E40, '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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Printing Excel Formulas without file paths updating Kim Excel Discussion (Misc queries) 0 August 18th 05 04:55 PM
Simple formulas in existing Excel 2002 no longer working. AllieB Excel Worksheet Functions 3 May 3rd 05 04:14 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 12:22 AM
Problems with Excel formulas when 2002 upgraded to XP Kathi McGraw Excel Worksheet Functions 0 November 16th 04 05:27 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"