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

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

=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

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

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

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

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