Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?
=IF(SUM(B$33:B$44)0,"x","")
I need to have the "x" (or nothing) to appear in cell B29 based on th SUM shown BUT I want to move the actual formula out of B29 so tha clearing cell B29 will not have an effect on the working of th formula. Cell B29 would be completely empty. Sounds rather simple but I can't figure it out. Maybe it sounds simpl because it's impossible. Thanks -- Message posted from http://www.ExcelForum.com |
Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?
You must use the Change event
Read Chip Pearson's site about Events http://www.cpearson.com/excel/events.htm Copy this in the worksheet module Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Application.Intersect(Range("B33:b44"), Target) Is Nothing Then If Application.WorksheetFunction.Sum(Range("B33:b44") ) 0 Then Range("B29").Value = "x" Else Range("B29").Value = "" End If End If End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Joe Cramblit " wrote in message ... =IF(SUM(B$33:B$44)0,"x","") I need to have the "x" (or nothing) to appear in cell B29 based on the SUM shown BUT I want to move the actual formula out of B29 so that clearing cell B29 will not have an effect on the working of the formula. Cell B29 would be completely empty. Sounds rather simple but I can't figure it out. Maybe it sounds simple because it's impossible. Thanks! --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com