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

Combining formulas
 

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

Combining formulas
 

=IF(AND(ISBLANK(A33),ISBLANK(A34)),"",IF(A34="12x" ,B34*0.7*0.8,IF(A34="6x",B34*0.7*0.5,IF(A33<"",(S UM((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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552424

Combining formulas
 

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

Combining formulas
 

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

Combining formulas
 

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

Combining formulas
 

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

Combining formulas
 

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

Combining formulas
 

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552424

Combining formulas
 

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

Combining formulas
 

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

Combining formulas
 

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