Excel Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column A B C
C=A*B
If A*B<S200 C=$200
If A or B = 0, C=0

How to copy Sentence to another cell

Thanks in advance for your help......MK
 
Not sure, but think you could try
putting in C1, and copy down:
=IF(OR(A1=0,B1=0),0,MAX(A1*B1,200))
 
You must log in or register to reply here.

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

Excel 2
Having Blank Cells, etc. ? 1
What do you use your R-Pi for - which Projects are you planning!? 1
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
tiny discrepancies in fixed-point numbers 3
Excel VBA 1
=IF(ISNA(VLOOKUP(A1,Data!$B$1:$C$200,MATCH(A1,Data!$A$1:$C$1,IF($V 3
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6

Back
Top