# 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

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.``

3. ## Re: Combinate formula with 2 variable

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

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.

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1