Changing cell values that are empty using formulas

[zendog1960]

It's been a while since I las posted anything. I has trying something in excel but I am not sure if it's possible. Here's the problem:

A1 is a blank cell. No formulas or anything.
B1 let's say has a value of 1.33
In C1, I would like to create a formula that will if B1 is not blank, the make A1 = B1.

I am doing this in an attempt to keep A1 clean of Formulas so if the user knows the value of A1, they can be directly inputted into A1.

I hope I explained this with enough clarity to get an answer. It funny how you know what you want to do but it's far more difficult to express into words. I digress, Any help would be extremely appreciated, and as always, thank you in advance!

Zendog

 

[Yongle]

In C1, I would like to create a formula that will if B1 is not blank, the make A1 = B1.

You cannot do that by formula
- the formula would need to be in A1 if you want A1 = B1

This formula returns the value of B1 if B1 is not empty
=IF(ISBLANK(B1),"",B1)

 

[zendog1960]

Thanks Yongle. At bit of wishful thinking I guess. Time to roll up the sleeves and dig into VBA again. Was kinda hoping to avoid that but such is the life in excel!