Thank you so much . But I'm afraid that I probably didn't explain that
correctly.
I was trying to enter a formula so as to change the ( 1 ) to 20 seconds.
So if I enter ( 2 ) in A1 my result in C2 or B2 would be ( 40 )..
Again thank you
Just enter this formula in whatever cell you choose then
=if(A1="","",20*A1)
Thank you so much . But I'm afraid that I probably didn't explain that
correctly.
I was trying to enter a formula so as to change the ( 1 ) to 2
seconds.
So if I enter ( 2 ) in A1 my result in C2 or B2 would be ( 40 )..
Again thank you
Thank you thank you.. That was great .. As you can tell I'm a real novice
excel user.
Actually dummy excel user... So really thanks again.. I spent three hours
trying to work that out ...
You are more than welcome ... I am just glad that I can help as I hav
had received a lot of help from here as well.
Don't sweat it because you are, in your words, "a real novice exce
user." Everyone here, even the experts, were novices at one time o
another.
Thank you thank you.. That was great .. As you can tell I'm a rea
novice
excel user.
Actually dummy excel user... So really thanks again.. I spent thre
hours
trying to work that out ...
Once again here I am.. Can you maybe explain to me how? I could make that
work in another cell like >> B1, B2 I've tried switching the letters in the
same formula but, have had no luck .. I can change the number alright ..
Maybe it is better if I just explain to you what the formula means an
you can take it from there.
The formula entered in cell C2, *-=if(A1="","",20*A1)-* is interprete
as follows:
1. If Cell A1 is blank, THEN Cell C2 is also a blank
2. ELSE (or otherwise) Cell C2 will have a value of "*20 multiplied b
whatever number is in Cell A1."*
< Mike said:
Once again here I am.. Can you maybe explain to me how? I could mak
that
work in another cell like >> B1, B2 I've tried switching the letter
in the
same formula but, have had no luck .. I can change the number alrigh
.. >>
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
