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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks