need to Combining formulas

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!
--
Krista

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!
--
Krista


"Bearacade" wrote:

>
> What happens if there is a value in A33 AND A34?
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=552424
>
>

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!

--
Krista


"Bearacade" wrote:

>
> 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?
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=552424
>
>

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

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

Thanks.
--
Krista


"Bearacade" wrote:

>
> 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,""))
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=552424
>
>

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

Steve

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


"SteveG" wrote:

>
> 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
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=552424
>
>

My bad ... I figured it out.

Thanks again!

--
Krista


"Krista" wrote:

> 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.
> --
> Krista
>
>
> "SteveG" wrote:
>
> >
> > 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
> >
> > Steve
> >
> >
> > --
> > SteveG
> > ------------------------------------------------------------------------
> > SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> > View this thread: http://www.excelforum.com/showthread...hreadid=552424
> >
> >