Hey Guys ,
please I need your help, I have a excel sheeet
A1-A10 , B1-A10, C1-C10
I would like to put a formula that enable me for example
if I put 0 ( zero ) in A1 , then B1 and C1 will automatilly filled with Zero
and so on for A2 , B2 and C2 will be 0 zero
any help please
Antonio
Hi,
in B1=A1 & in C1=A1
Then drag it
Please consider adding a * if I helped
In B1 enter:
=IF(A1=0,0,"") and copy down
In C1 enter:
=IF(A1=0,0,"") and copy down
Gary's Student
Maybe this...
Entered in B1:
=IF($A1="","",$A1)
Copy across to C1 then down as needed.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
all of those either give a1 if its any value or 0
B1=A1 & in C1=A1 if a1 =blank gives 0 in both
=IF(A1=0,0,"") if a1= blank gives 0 in both
=IF($A1="","",$A1) gives whatever value is in a1 not just 0
you need to test a1 for blank as well
=IF(AND($A1=0,$A1<>""),$A1,"") fill across to c1 then down
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
kuzna,
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.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks