| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help rounding up - THX Mike/Thomas for previous answer
One more question for you, if p53=2.35 but is not m53/.85, the if command
is still answering 2.35 since it ends in .05. How can I get it to go up to 2.40? "Mike H" wrote: Hi, You don't need the quotes or the = sign =IF(P53M53/0.85,P53,CEILING(P53,0.05)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help rounding up - THX Mike/Thomas for previous answer
There's no need for another thread, go back to the other one, you have an
answer there "tarabull" wrote: One more question for you, if p53=2.35 but is not m53/.85, the if command is still answering 2.35 since it ends in .05. How can I get it to go up to 2.40? "Mike H" wrote: Hi, You don't need the quotes or the = sign =IF(P53M53/0.85,P53,CEILING(P53,0.05)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help rounding up - THX Mike/Thomas for previous answer
sorry
"Mike H" wrote: There's no need for another thread, go back to the other one, you have an answer there "tarabull" wrote: One more question for you, if p53=2.35 but is not m53/.85, the if command is still answering 2.35 since it ends in .05. How can I get it to go up to 2.40? "Mike H" wrote: Hi, You don't need the quotes or the = sign =IF(P53M53/0.85,P53,CEILING(P53,0.05)) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help rounding up - THX Mike/Thomas for previous answer
Just trying to keep the forums clean I see.
-- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Mike H" wrote: There's no need for another thread, go back to the other one, you have an answer there "tarabull" wrote: One more question for you, if p53=2.35 but is not m53/.85, the if command is still answering 2.35 since it ends in .05. How can I get it to go up to 2.40? "Mike H" wrote: Hi, You don't need the quotes or the = sign =IF(P53M53/0.85,P53,CEILING(P53,0.05)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need you Mike H! | Excel Worksheet Functions | |||
| Subtracting Dates - Mike | Excel Discussion (Misc queries) | |||
| rounding the answer of a formula | New Users to Excel | |||
| Usernames and Passwords--Thomas Homan | Excel Worksheet Functions | |||
| Mike | Excel Discussion (Misc queries) | |||
Linear Mode
