Excel

S

Suleman

HEllo
i need to apply a Formula Like

If

A1 is equale to 50
that time


B1 is autumatically come to equale the c3
 
B

Beth Melton

I'm not exactly sure what you are trying to accomplish but I think you need
something like:

=IF(A1=50, "that time", B1=C3)

Syntax: =IF(Conditional_Test,What_to_do_if_True, What_to_do_if_False)

So "that time" would be whatever you want Excel to do if A1=50. I'm not sure
what you want for the False part or what you mean by B1=C3 but hopefully
this will get you started.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx

Suleman said:
HEllo
i need to apply a Formula Like

If

A1 is equale to 50
that time


B1 is autumatically come to equale the c3
Click to expand...


--
 
S

Suleman

yah i think i can,t explain you right way

Example :

i want that when A1 come to 3rd July 2008 that time C4=C4
its mean
as A1 come to the date of 3rd July that time the amount of cell B1 same
amount convert to the C1.

A1 B1 C1

22 rd july 86 .....

next day as the date update and A1 cell Come To 23rd july

A1 B1 C1
23 rd july 86 86

EXample :

supose
 
S

Suleman

yah i think i can,t explain you right way

Example :

i want that when A1 come to 3rd July 2008 that time C4=C4
its mean
as A1 come to the date of 3rd July that time the amount of cell B1 same
amount convert to the C1.

A1 B1 C1

22 rd july 86 .....

next day as the date update and A1 cell Come To 23rd july

A1 B1 C1
23 rd july 86 86
 
Top