Hello,
I am trying to get two formulas to work in one cell? Just can not figure out the right sequence.
=E2/(1-40%)
and
=If(CEILING(E2,0.05) = CEILING(E2, 0.1), CEILING(E2, 0.05)-0.01, CEILING(E2, 0.05))
Thanks JR
Hello,
I am trying to get two formulas to work in one cell? Just can not figure out the right sequence.
=E2/(1-40%)
and
=If(CEILING(E2,0.05) = CEILING(E2, 0.1), CEILING(E2, 0.05)-0.01, CEILING(E2, 0.05))
Thanks JR
Do you mean?
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hello,
thank you very much. I think that is very close. With this I get 38.9333333333333 23.39, but the final result I need is 38.95.
Thank you
Formula:
Please Login or Register to view this content.
Which is the result that you get using this formula?
Formula:
Please Login or Register to view this content.
Which is the result that you get using this formula?
Hello,
Got it.
Cell E2 = 23.36
Cell F2 -> When I use this formula =E2/(1-40%), I get 38.93
Cell G2 -> When I use this formula =If(CEILING(F1,0.05) = CEILING(F1, 0.1), CEILING(F1, 0.05)-0.01, CEILING(F1, 0.05)), it gets me to 38.95
I would like 38.95 to show in cell F2.
Thanks Jr
I have to say that you comfused me!
1)What number do you have in F1?
2)As you get in G2 the number that you want(38.95) why don't you just type in F2 =G2 ?
Hello,
Sorry I am not explaining very well. Maybe this may be easier for me to explain. How do I combine the two following formulas in one cell,
=E2/(1-40%)
And
=MROUND(E2,0.05)
So formula =E2/(1-40%) is calculated then =MROUND(E2,0.05) will round it to the nearest .05.
Thanks JR
=mround(E2/(1-40%),0.05)
I guess?
Do you wish:
=MROUND(E2/(1-40%),0.05)
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Hello,
Thank you very much. This worked perfect,
=MROUND(E2/(1-40%),0.05)
JR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks