Max Formula
 

Excel 2007
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31

Max Formula
 

Try this:

=MIN(300,B35*C31)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Canon" wrote in message
...
Excel 2007
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31

Max Formula
 

=IF(C33=0,"NILL",MIN(300,B35*C31))

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Canon" wrote:

Excel 2007
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31

Max Formula
 

"Canon" wrote:
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31

I think this is what you want:

=if(C33=0, "", min(300, B35*C31))


----- original message -----

"Canon" wrote in message
...
Excel 2007
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31

Max Formula
 

In article ,
Canon wrote:

Excel 2007
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31

Try replacing...

B35*C31

with

MIN(300,B35*C31)

--
Domenic
http://www.xl-central.com

Max Formula
 

=IF(C33=0,"NILL",MIN(B35*C31,300))
--
David Biddulph

"Canon" wrote in message
...
Excel 2007
I am working with the following formula;
=IF(C33=0,"NILL",B35*C31)
If the sum (in C35) of B35*C31 is equal to or greater then $300.00, then I
need C35 to show a maximum of $300.00, if not I need C35 to show the true
value of B35*C31