Combine 2 formulas

[F4TMAN]

Hello,

I'm in need of some help here, I have two formulas that i would like to combine.

The first Formula looks like this

=IF((VLOOKUP($B65,$B$42:$B$55,1,FALSE))=$B65,(RegionCost!N$29*$X42+M42),"")

The second formula looks like this

=RegionCost!N28*(1+$N$81)-M56

I'm referencing a tab sheet in there but ultimately i would like to get the resulting number using the combination of these two. If additional information is needed please let me know. Thanks

 

[Lee J]

Hi F4TMAN,

Depends what you want to do, either way both formula need encasing in brackets (formala) and then:

To add them together then just put a + between the two
To multiply them together just put a * between the two

Hope that helps