Hello All:
I am trying to Combine =(B6*M6)and IF(C6<150,150,C6) in C6 I don't get an error but I get $ - . The first formula should give me $30.00 and if the second formula kicks in and evaluate it should change the 30.00 to 150.00. can somebody shed some light on this for me as to why I am getting $ - and if you can show me how to accomplish combining the two formulas correctly. Each one works right on its own. This is how I combined them --- =B6*M6,IF(C6<150,150,C6)

Regards
Ardy

In C6 type the following formuula

IF((B6*M6)<150,150,(B6*M6))

On Wednesday, March 13, 2013 2:46:45 PM UTC, Ardy wrote:
Hello All:

I am trying to Combine =(B6*M6)and IF(C6<150,150,C6) in C6 I don't get an error but I get $ - . The first formula should give me $30.00 and if the second formula kicks in and evaluate it should change the 30.00 to 150.00. can somebody shed some light on this for me as to why I am getting $ - and if you can show me how to accomplish combining the two formulas correctly. Each one works right on its own. This is how I combined them --- =B6*M6,IF(C6<150,150,C6)



Regards

Ardy

hi Ardy,

Am Wed, 13 Mar 2013 07:46:45 -0700 (PDT) schrieb Ardy:

I am trying to Combine =(B6*M6)and IF(C6<150,150,C6) in C6 I don't get an error but I get $ - . The first formula should give me $30.00 and if the second formula kicks in and evaluate it should change the 30.00 to 150.00. can somebody shed some light on this for me as to why I am getting $ - and if you can show me how to accomplish combining the two formulas correctly. Each one works right on its own. This is how I combined them --- =B6*M6,IF(C6<150,150,C6)

try:
=MAX(B6*M6,150)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Wednesday, March 13, 2013 10:14:22 AM UTC-7, Claus Busch wrote:
hi Ardy,



Am Wed, 13 Mar 2013 07:46:45 -0700 (PDT) schrieb Ardy:



I am trying to Combine =(B6*M6)and IF(C6<150,150,C6) in C6 I don't get an error but I get $ - . The first formula should give me $30.00 and if the second formula kicks in and evaluate it should change the 30.00 to 150..00. can somebody shed some light on this for me as to why I am getting $ - and if you can show me how to accomplish combining the two formulas correctly. Each one works right on its own. This is how I combined them --- =B6*M6,IF(C6<150,150,C6)



try:

=MAX(B6*M6,150)





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Thanks It works, Actually both solutions work great......Thanks guys....

On Wednesday, March 13, 2013 9:59:46 AM UTC-7, Nano wrote:
In C6 type the following formuula



IF((B6*M6)<150,150,(B6*M6))



On Wednesday, March 13, 2013 2:46:45 PM UTC, Ardy wrote:

Hello All:



I am trying to Combine =(B6*M6)and IF(C6<150,150,C6) in C6 I don't get an error but I get $ - . The first formula should give me $30.00 and if the second formula kicks in and evaluate it should change the 30.00 to 150..00. can somebody shed some light on this for me as to why I am getting $ - and if you can show me how to accomplish combining the two formulas correctly. Each one works right on its own. This is how I combined them --- =B6*M6,IF(C6<150,150,C6)







Regards



Ardy
Thanks . It Works......