Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Not sure, but think you could try
putting in C1, and copy down: =IF(OR(A1=0,B1=0),0,MAX(A1*B1,200)) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "MK" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
Excel Question....Help !!!! | Excel Discussion (Misc queries) | |||
eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |