excel formulas
 

How do you do formula's, calculations? If the condition in b15 is yes, then
the value in column d would change to whatever is in column F. If the
condition is no, then there would be a 0? I'm unfamiliar with doing formula's.
Thanx

excel formulas
 

For example In D30 this formula

=IF($B$15="yes",F30,0)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"troy stud" wrote in message ...
How do you do formula's, calculations? If the condition in b15 is yes, then
the value in column d would change to whatever is in column F. If the
condition is no, then there would be a 0? I'm unfamiliar with doing formula's.
Thanx

excel formulas
 

=IF(B15="Yes",D15=F15,0)
--
Brevity is the soul of wit.


"troy stud" wrote:

How do you do formula's, calculations? If the condition in b15 is yes, then
the value in column d would change to whatever is in column F. If the
condition is no, then there would be a 0? I'm unfamiliar with doing formula's.
Thanx

excel formulas
 

I see the formulas but how do they go into an excel sheet and how do they
work? It sounds like he wants to type a yes or no into b15 or maybe even d15?
If the answer is yes, he wants d15 and f15 to match, such as 14,000, if it's
no then 0 for an amount?

"Dave F" wrote:

=IF(B15="Yes",D15=F15,0)
--
Brevity is the soul of wit.


"troy stud" wrote:

How do you do formula's, calculations? If the condition in b15 is yes, then
the value in column d would change to whatever is in column F. If the
condition is no, then there would be a 0? I'm unfamiliar with doing formula's.
Thanx

excel formulas
 

That doesn't give the value of whatever is in column F, it gives a true or
false depending on whether D15 and F15 are equal (and of course it gives a
circular reference if you put it in D15).

Try Ron's formula.
--
David Biddulph

"Dave F" wrote in message
...
=IF(B15="Yes",D15=F15,0)
--
Brevity is the soul of wit.


"troy stud" wrote:

How do you do formula's, calculations? If the condition in b15 is yes,
then
the value in column d would change to whatever is in column F. If the
condition is no, then there would be a 0? I'm unfamiliar with doing
formula's.
Thanx