Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |