LinkBack URL
About LinkBacks
Hi there!
I want to write a function or formula in cell a1 that print the name "john" in cell b1 if cell c1 is not blank.
What function or formula can do taht task?
I'm using excel 2010.
Tanks for your help!!!
Hi there!
I want to write a function or formula in cell a1 that print the name "john" in cell b1 if cell c1 is not blank.
What function or formula can do taht task?
I'm using excel 2010.
Tanks for your help!!!
Hi
Why, just don't use this in B1?
=IF(C1<>"","John","")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks for your answer fortis:
but initially I want a default value or label in cell b1 that will change to "John" if I enter an input in c1.
You cannot have a formula in one cell that puts a value in another cell. Please explain better and don't use vague language like "... a default value ..."
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks