Hello,
I need help. for example, in cell D1 I want excell to automatically enter some text based on which cell A1, B1 or C1 I filled.
More details:if a put something (no matter what) in:
- cell A1, value in the cell D1 needs to be 'car'
- cell B1, value of the D1 would be 'house'
- cell C1, value od the D1 would be 'road'.
I asume the correct function should be not(isblank) but I don't know how to use it
thanks in advance.
--
palcic-albert
if a1<>"" ,true, false
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
tRY
=IF(COUNTA(A1),"CAR",IF(COUNTA(B1),"HOUSE",IF(COUNTA(C1),"ROAD")))
☚ Click ★ just below left if it helps, Boo?ath?
Try this......
In D1
OR
Please Login or Register to view this content.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Will there only be one cell with data in A1:C1 ?
What type of data would be in the cell, Text or Number. Or could be either?
Try entering this in D1, as an array formula (Ctrl-Shift-Enter)
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Or this
=IFERROR(INDEX({"Car","House","Road"},SMALL(IF(A1:C1<>"",COLUMN(A1:C1)),1)),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi, welcome to the forum
Assuming you are testing for either cell is blank or cell has contents, and that only 1 of the 3 will have contents, here is an alternative...
=IF(A1="","CAR",IF(B1="","HOUSE",IF(C1"","ROAD")))
If 1 of the 3 will always have contents, you can shorten that to...
=IF(A1="","CAR",IF(B1="","HOUSE","ROAD"))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
thanks to all for help, but (I don't know what the problem is) every formula I copy/paste return an error (with just enter or ctrl-shift-enter). for example, on the last one from FDibbins, excell select this:
,"CAR",IF
Or in the formula:
=IFERROR(INDEX({"Car","House","Road"},SMALL(IF(A1:C1<>"",COLUMN(A1:C1)),1)),"")
bold are:
"Car","House","Road".
maybe some option setting is wrong?
May be you should use ; (semicolon) instead of , (comma) in the formulas. See if this helps.
that helps, _I replace all , with ;
thanks everyone!
--
p-a
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks