Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|