LinkBack URL
About LinkBacks
I need a formula will do this in Excel
If cell in column BE is blank, then cell value is equal to the value of cell AM. If not blank leave as is.
I need a formula will do this in Excel
If cell in column BE is blank, then cell value is equal to the value of cell AM. If not blank leave as is.
if you are saying you want either a value in a cell or a formula you can't do that with formulas. You will likely need VBA for that. unless you want to go by hand down the column copying this formula =AM1. You'd have to jump between each cell that has something in it and paste that in each blank cell. So if BE1 is blank you put that in it, then if BE15 is blank you paste that in it (it will update to AM15) etc.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
try:
=IF(BE1="",AM1,any cell)
If I've helped U pls click on d *Add Reputation
Hi there, I think the below may solve it.
=IF(ISBLANK(BE1),AM1,Value wanted)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks