Another IF statement
 

I have a minimum order quantity that must be maintained.

Content of cell A1 will vary, B1 will be constant (90) and C1 will be the
resulting cost.

C1 has a minimum order charge of 180 applied to it so:

C1 needs to show 0 when A1 is 0
C1 needs to show 180 when A1 is 1
C1 needs to show variable of A1 x B1 above 180

I hope this is clear.

Many thanks,

Dave

Another IF statement
 

Try in C1: =IF(A1=0,0,MAX(A1*B1,180))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Dave in Ampthill" wrote:
I have a minimum order quantity that must be maintained.

Content of cell A1 will vary, B1 will be constant (90) and C1 will be the
resulting cost.

C1 has a minimum order charge of 180 applied to it so:

C1 needs to show 0 when A1 is 0
C1 needs to show 180 when A1 is 1
C1 needs to show variable of A1 x B1 above 180

Another IF statement
 

Perfect, many thanx. :)

"Max" wrote:

Try in C1: =IF(A1=0,0,MAX(A1*B1,180))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Dave in Ampthill" wrote:
I have a minimum order quantity that must be maintained.

Content of cell A1 will vary, B1 will be constant (90) and C1 will be the
resulting cost.

C1 has a minimum order charge of 180 applied to it so:

C1 needs to show 0 when A1 is 0
C1 needs to show 180 when A1 is 1
C1 needs to show variable of A1 x B1 above 180

Another IF statement
 

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Dave in Ampthill" wrote in
message ...
Perfect, many thanx. :)