Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" then questio
Say I wanted to write a formula which did this "I want the equation to show
all values at or above 10 as "10" and I want all values below 10 to show the answer as is with no manipulation. So, it would like like this "if 5+6=11 then it will display as 10, but if the two sums are 3+4=7 then the answer will display as 7 because it is below 10. Again it would be like this "if 17+50=67then it will display as 10, but if the answer to the equation is below 10 then it will be displayed as that number. =IF((YEAR(B$8)-YEAR(H30))*12+MONTH(B$8)-MONTH(H30)=10,"10","O30") The reference cell of "O30"is the problem area I'm running into. It wants to litterly display the text "O30", instead of the value that is in "O30". Assuming that value is under 10. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" then questio
I haven't tested your logic, but take the quotes off the last 2 items, unless
you want the 10 as text, the "" around O30 will place just O30 in the cell. Try this: =IF((YEAR(B$8)-YEAR(H30))*12+MONTH(B$8)-MONTH(H30)=10,10,O30) -- -John Please rate when your question is answered to help us and others know what is helpful. "Excel Trouble" wrote: Say I wanted to write a formula which did this "I want the equation to show all values at or above 10 as "10" and I want all values below 10 to show the answer as is with no manipulation. So, it would like like this "if 5+6=11 then it will display as 10, but if the two sums are 3+4=7 then the answer will display as 7 because it is below 10. Again it would be like this "if 17+50=67then it will display as 10, but if the answer to the equation is below 10 then it will be displayed as that number. =IF((YEAR(B$8)-YEAR(H30))*12+MONTH(B$8)-MONTH(H30)=10,"10","O30") The reference cell of "O30"is the problem area I'm running into. It wants to litterly display the text "O30", instead of the value that is in "O30". Assuming that value is under 10. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |