Condensing Formulas

[Philbowen]

Hi Excel boffins

This is my first post, so I am not sure if I am asking the correct question in the correct place, but here goes:


I have the following formula in cell D3
=((B3-$D$2)*1.17)

And I have following formula in cell E3

=IF(D3<0,"Free",ROUNDUP(D3/100,0)*100-1)

I would like to have both the above formulas in a single cell, D3

Thanks in advance

 

[anandvarma]

try this

=if(((B3-$D$2)*1.17)<0,"Free",ROUNDUP(((B3-$D$2)*1.17)/100,0)*100-1

 

[Ruddles]

I have the following formula in cell D3
=((B3-$D$2)*1.17)

And I have following formula in cell E3

=IF(D3<0,"Free",ROUNDUP(D3/100,0)*100-1)

I would like to have both the above formulas in a single cell, D3

As a general method:-

1. The bit in red is equivalent to the bits in blue, so replace the bits in blue with the bit in red.
2. Make sure the formula in E3 works, then clear the contents of D3 and make sure the formula in E3 still works.
3. Finally move the formula from E3 to D3 and make sure it still works.