Variable Symbol

[kashyap]

Hi, How to make + symbol variable in the below formula?
This formula is in G25 and symbol is in F25 has + & - symbols

=(NOW()-E$592)+E614

 

[Scott Huish]

If you are looking to add or subtract based on what is in F25:

=NOW()+(E$592*(IF(F25="+",1,-1)))+E614

 

[pgc01]

Hi kashyap

Another option: Instead of +/- in F25 write 1/-1, and use

=(NOW()-E$592)+F25*E614

 

[kashyap]

I'm getting<TABLE style="WIDTH: 100pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=133 border=0 x:str><COLGROUP><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl32 id=td_post_1915408 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 100pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=133 height=17 x:num="39927.259738888897">Fri 24 Apr 2009 06:14</TD></TR></TBODY></TABLE>expected is <TABLE style="WIDTH: 100pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=133 border=0 x:str><COLGROUP><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl32 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 100pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=133 height=17 x:num="39926.593428587963">Thu 23 Apr 2009 14:14

<!-- / message --><!-- sig --></TD></TR></TBODY></TABLE>

 

[Scott Huish]

What values do you have in all 3 cells?

 

[kashyap]

I have time in all 3 cells

 

[Scott Huish]

Ok, but what times? What are the values? How does F25 contain a time, I thought it contained a + or -?

 

[kashyap]

Col E |Col F |Col G
02:00 |+ |09:03


E592=05:30

 

[Scott Huish]

Assuming the 2:00 is in E614, with my formula I get right now (at time of 9:24 AM):
Fri 24 Apr 2009 16:54

 

[kashyap]

Yap... I got it finally..

But why am I not able to format cell as date when I use =E4&G4 ?