leaving cell blank if another cell blank , else do formula

**o5889436** · 09-13-2012, 03:47 PM

Trying to have a cell, lets say Sheet2 A1 = Sheet1 A1 using the following:

=IF(A48="","",=A48)... Does not work

=IF(A48="","",IF(A48>0,A48,"")) Does work....

IS my syntext wrong? I thought it was easier than that. Beleive it or not, I use excel functions, vba, formulas a lot. Why is this little guy bugging me so much?

**JieJenn** · 09-13-2012, 03:50 PM

Get rid of the equal sign

=IF(A48="","",A48)

**Ace_XL** · 09-13-2012, 03:52 PM

remove the = sign before A48
hence,
=IF(A48="","",A48)

**simon1234** · 09-13-2012, 04:00 PM

I would use this formula instead =IF(A48>0,A48,"")
does exactly the same as the second one you have posted
as for the first one 0 is not an empty string it is a value thats why it will display

though im confused by your first sentence
"Trying to have a cell, lets say Sheet2 A1 = Sheet1 A1 using the following:"
as none of those formulas will do that

**o5889436** · 09-13-2012, 05:46 PM

Isn't it amazing how you can look at a formula for hours and still miss the obvious? Thanks to all for the help... But I did forget to mention that the cell this formula was checking was a list box... I just wanted to copy whatever the entered in the first sheet... thanks!

Was...
=IF(A48="","↓REQUIRED↓","")
=IF(A48="","",IF(A48>0,A48,""))

Now...
[A94] =IF(A95="","↓REQUIRED↓","")
[A95] =IF(A48="","",A48)

We will discuss my noobe move with no one....

**arlu1201** · 09-14-2012, 05:07 AM

o5889436,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.