Another IF statement

D

Dave in Ampthill

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inventory 10
Combining two formulas 0
Complicated IF statement - desperately need some help 4
Running total with IF statements 2
Nested IF Help 3
Sort issue Sort Of 3
Using icon sets with relative references 0
MACRO RUN random percentage and copy of column values 1

Top