excel formulas

T

troy stud

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
 
T

troy stud

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?
 
D

David Biddulph

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.
 
Top