# Combinate formula with 2 variable

1. ## Combinate formula with 2 variable

Hello all,

I have 2 cells with variables. If, like in this exemple B4 = 0, than I have to do the calculaction with the value in B5. If B5 = 0 than I have to do it with the value of B4
Actually I use 2 formulas. Is there a way to combinate this in one formula? This means if the value in one of both is 0, than calculate with the value in the other cell

dekueb  Register To Reply

2. ## Re: Combinate formula with 2 variable

is it as easy as this? may be I'm not clear on the issue ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: Combinate formula with 2 variable

or
=(B1*B2-C3)/B6*12*IF(B4=0,B5,B4)  Register To Reply

4. ## Re: Combinate formula with 2 variable Originally Posted by Crooza is it as easy as this?

Great joke Crooza. Easy for you, Impossible for me

Thank you. Works perfect.  Register To Reply

5. ## Re: Combinate formula with 2 variable Originally Posted by samba_ravi or
=(B1*B2-C3)/B6*12*IF(B4=0,B5,B4)
Work also great
Thank You  Register To Reply