| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If part of a cell = "NVA" then insert "Norfolk" in return cell | Excel Worksheet Functions | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. | Excel Programming | |||
Threaded Mode
