Formulas

[Sharlene]

I have a question about writing a formula.

the value of b3-c3=d3, I already have that but if the value is greater than
5, I want the value in E3. If the value of d3 is less than 5 iI want the
contents in F3.
Can Somebody help me please, I would really appreciate it

 

[FSt1]

hi
=if(D3>5,E3,F3)
this formual ignore the quantity 5. somewhere in there you should have >=5
so as not to have the number 5 omitted from the formula.

regards
FSt1

 

[Snook]

In Cell E3 put: =IF(D3>5,D3,"")

In Cell F3 put: =IF(D3<5,D3,"")

 

[T. Valko]

A formula can't "push" a value to another cell. You'd need to have formulas
in both E3 and F3 that "pull" the result to their respective cells.

E3: =IF(AND(COUNT(D3,D3>5),D3,"")

F3: =IF(AND(COUNT(D3,D3<5),D3,"")

What if the value of D3 *is* 5 ?