FOrmula Help Please, Im so confused

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

I have a formula that outs out net margin which is

=(Margins!$C$6-MIN-'TMobile 18 Costs'!D5)

I also have another formaula that turns negative into positive If a
positive states "FOC" if negative adds VAT and rounds up to nearest
9.99.

=IF(C8>=0,"FOC",CEILING(-C8*1.175,10)-0.01)

So if a neative was -89 turns it into +89 *1.175 = 105 then changes it
to 109.99 automatically

With me so far. So what i need is a formula that does all that in one
formula so i dont have to create double columns ot work it out!!!!!!
 
Either

=Margins!$C$6-MIN-IF('TMobile 18 Costs'!C8>=0,"FOC",CEILING(-'TMobile 18
Costs'!C8*1.175,10)-0.01)

or

=IF(Margins!C8>=0,"FOC",CEILING(-Margins!C8*1.175,10)-0.01)-MIN-'TMobile 18
Costs'!D5


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top