Combining formulas

[Guest]

I can't seem to wrap my head around this. I need to combine the following
two formulas so that the result appears in one cell:

=IF(A33="","",(SUM((2815*30)*A33)))
=IF(A34="","",IF(A34="12x",B34*0.7*0.8,IF(A34="6x",B34*0.7*0.5,0)))

Thanks!

 

[Bearacade]

What happens if there is a value in A33 AND A34?

 

[Bearacade]

=IF(AND(ISBLANK(A33),ISBLANK(A34)),"",IF(A34="12x",B34*0.7*0.8,IF(A34="6x",B34*0.7*0.5,IF(A33<>"",(SUM((2815*30)*A33)),0))))

This will first check A34 for any value, if nothing, then show the
result best on the value in A33.

If A33 has a value but A34 has either 6X or 12X, the A34 is used and
A33 ignored

 

[Guest]

Sorry 'bout that ... it's all on the same row. This is a better
representation:

=IF(D33="","",(SUM((2815*30)*D33)))
=IF(E33="12x",F33*0.7*0.8,IF(E33="6x",F33*0.7*0.5,0)))

In the second calc F33 is the total of the first calc.

Thanks!

 

[Bearacade]

I am sorry, but you lost me. I have no idea what is in what cell =(

Can you tell me where you have these two formula? and where you want
the new formula to be and what you want it to do?

 

[Guest]

OK, I figured out a way around my initial question, but I have another
question ... completely different from the first. How can I change the
following formula to be where E33 starts with 12x or 6x?

=IF(E33="","",IF(E33="12x",F33*0.7*0.8,IF(E33="6x",F33*0.7*0.5,0)))

Thanks!

 

[Bearacade]

You mean:

=IF(E33="12x",F33*0.7*0.8,IF(E33="6x",F33*0.7*0.5,""))

or

=IF(E33="6x",F33*0.7*0.5,IF(E33="12x",F33*0.7*0.8,""))

 

[Guest]

No. I need to know how to change the formula to instead of

="12x" or ="6x"
to
starts with "12x" or "6x"

Thanks.

 

[Bearacade]

Sorry Krista, I am still no understanding your question... what do you
mean by Start with?

 

[SteveG]

Krista,

Do you mean if the first 3 characters are "12x" or first 2 are "6x"?

Try,


=IF(E33="","",IF(LEFT(E33,3)="12x",F33*0.7*0.8,IF(LEFT(E33,2)="6x",F33*0.7*0.5,0)))

HTH

Stev

 

[Guest]

Yes, that's what I mean -- thanks.

I tried this formula; however, nothing is appearing. I initially thought
that's what the formula should be; however, it's not calculating ... the
field is blank.

Thanks.

 

[Guest]

My bad ... I figured it out.

Thanks again!