FOrmula Help Please, Im so confused "Carl" <carl[ at ]ace-contact.com> 18.09.2006 09:46:11 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!!!!!!

Re: FOrmula Help Please, Im so confused "Bob Phillips" <bob.NGs[ at ]somewhere.com> 18.09.2006 10:46:02 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) "Carl" <carl[ at ]ace-contact.com> wrote in message news:1158572770.962375.245450[ at ]k70g2000cwa.googlegroups.com... [Quoted Text] > 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!!!!!! >