LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KimberlyC
 
Posts: n/a
Default Incorporating cell content into a message in a formula

Hi,
I'm using the following formula (located in A8) to alert the user when the
total in C9 does not equal the total in H7 on the Details worksheet.
=IF(C9<'Details'!H7,"Out of Balacne - Check your entries!","")

I would like to have the totals for C9 and H7 (on the Details worksheet )
show in the message ...but not sure how to incorporate that into the
formula...
Somthing Like:
"Out of Balance - your total of 1500 on this sheet should match your total
on the Details worksheet of 2000. Check your entries"

1500 is the total in C9 and 2000 is the total on the Details worksheet in
H7

Thanks in advance for your help!!
Kimberly :)



 
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
Cell addressing using the content of another cell. De Jandon Excel Worksheet Functions 5 April 1st 05 10:59 PM
Cell addressing using the content of another cell. Jandon Excel Worksheet Functions 1 March 30th 05 06:39 PM
How can I make the bar that shows the content of the cell visible. ZG Excel Discussion (Misc queries) 1 January 8th 05 07:27 PM
vlookup to extract part cell content excelFan Excel Discussion (Misc queries) 2 December 5th 04 08:45 AM
Transferring cell content between workbooks using cell references Kiwi Mike Excel Discussion (Misc queries) 2 November 27th 04 11:31 PM


All times are GMT +1. The time now is 02:33 AM.

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"