Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
hi
=if(D35,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 "Sharlene" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
In Cell E3 put: =IF(D35,D3,"")
In Cell F3 put: =IF(D3<5,D3,"") "Sharlene" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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,D35),D3,"") F3: =IF(AND(COUNT(D3,D3<5),D3,"") What if the value of D3 *is* 5 ? -- Biff Microsoft Excel MVP "Sharlene" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |