B
BenjieLop
Enter in cell C2
=if(A1=1,"Seconds","")
Could this be what you want?
=if(A1=1,"Seconds","")
Could this be what you want?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike
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
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
B
BenjieLop
Just enter this formula in whatever cell you choose then
=if(A1="","",20*A1)
=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
M
Mike
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 ...
excel user.
Actually dummy excel user... So really thanks again.. I spent three hours
trying to work that out ...
B
BenjieLop
Mike,
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.
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 ...
M
Mike
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 ..
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 ..
B
BenjieLop
Mike,
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."*
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
.. >>
------------------------------------------------------------------------BenjieLop's Profile http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread http://www.excelforum.com/showthread.php?threadid=270924
[/color