Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello All, I am fairly new to Excel formula programing. I know enough to be dangerous. Could some please help me here.
I need a traget cell left empty until I enter a value in one or more of the other cells that are part of a formula. How can I accomplish this or is it even possible? If you need further explanation I would be glad to send you a sample of what I am trying to do. Thanks again |
#2
![]() |
|||
|
|||
![]() Quote:
Suppose you want to add the contents of cell a1 to b1 and display the answer in c1, the formula for c1 is: =IF(A1="","",A1+B1) In other words, if A1 is blank display blank in c1 otherwise add a1 to b1 regards mjd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |