# IF Then Function with multiple Truths

1. ## IF Then Function with multiple Truths

Hello,

I am having some difficulty trying to figure out a certain formula

I want to do the following

I enter data in 3 columns
(Cases, Boxes, Pieces)
A1 B1 C1

I want to know if its possible to have a function that will populate boxes E1 F1 G1 with the following logic:

If A1>0 Then enter the value in A1 into E1, Then multiply the value A1 by 4 and enter that result into F1, Then multiply the value in A1 by 48 and enter that result into G1

If B1>0 Then Divide the value in B1 by 4 and enter that result into E1, then enter value of B1 into F1, Then multiply the value in B1 by 12 and enter that result into G1

If C1>0 Then divide the value in C1 by 48 and enter that result into E1, then divide the value in C1 by 12 and enter that result into F1, and enter the value in C1 into G1

I hope you guys can follow it..

Reference:
1 Case = 4 Boxes = 48 Pieces

Any suggestions are appreciated!!

2. ## Re: IF Then Function with multiple Truths

Will you only have one entry in cells A1, B1 and C1, or might you have a value in more than one of these cells? (so if you had 1, 4, 48 in those cells, that would be equivalent to 3 cases, 12 boxes, 144 pieces ?)

Pete

3. ## Re: IF Then Function with multiple Truths

That's correct Pete.

If A1 = 1 B1 will always equal 4 and C1 will always equal 48
If A2 = 2 B1 will always equal 8 and C1 will always equal 96
.
.
.
.
.
.
.
If A2 = 9 B1 will always equal 36 and C1 will always equal 432
_________________________________________________

If A1 = 1 then, B1 = (A1*4), C1 = (B1*12)
If B1 = 1 then, A1 = (B1/4), C1 = (B1*12)
If C1 = 1 then, A1 = (B1/4). B1 = (C1/12)

4. ## Re: IF Then Function with multiple Truths

Try this'
In e1 : =A1+(B1/4)+(C1/48)
In F1 : =(A1*4)+B1+(C1/12)
In G1 : =(A1*48)+(B1*12)+C1

copy down as far as needed

Hope this helps

5. ## Re: IF Then Function with multiple Truths

Fantastic!

Works like a charm.. thanks so much!

6. ## Re: IF Then Function with multiple Truths

You are very Welcome !

Don't forget to mark thread as solved if you are satisfied with the solution:

To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"

#### Thread Information

##### Users Browsing this Thread

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