| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
a+b<4 then 4,a+b<4 then sum a+b
WOW! THANKS FOR MAKING MY LIFE EASIER!
"Ron Coderre" wrote: Try this: C1: =MAX(A1+B1,4) That formula returns the greater of (A1+B1) or 4. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "maril" wrote: As you can tell with the subject line, I am having problems with a SIMPLE formula that I cannot get right. What I need is: if a1+b1 is less than 4 then c1 shows 4, but if a1+b1 is greater than 4 then c1 shows the sum of a1+b1. Can any one help me? many, many thanks! |
Threaded Mode
