| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function - with a twist!
Please help if you can.
I am using the IF function and will simplify what I need for explanation purposes: I have a value in A1 and a value in B1 and I want to display, in C1, the larger of the two. The twist is that if that value is not larger than 100, I want to display 100. Please help if you can. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function - with a twist!
Put this in C1:
=MAX(100,A1,B1) Hope this helps. Pete On Jul 2, 4:48*pm, Jamie wrote: Please help if you can. I am using the IF function and will simplify what I need for explanation purposes: I have a value in A1 and a value in B1 and I want to display, in C1, the larger of the two. *The twist is that if that value is not larger than 100, I want to display 100. * Please help if you can. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function - with a twist!
This will work
=IF(MAX(A1,B1)100,MAX(A1,B1),100) "Jamie" wrote: Please help if you can. I am using the IF function and will simplify what I need for explanation purposes: I have a value in A1 and a value in B1 and I want to display, in C1, the larger of the two. The twist is that if that value is not larger than 100, I want to display 100. Please help if you can. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum with a twist | Excel Discussion (Misc queries) | |||
| Function To Add across Multiple Sheets with a Twist | Excel Worksheet Functions | |||
| SaveCopyAs with a twist | Excel Discussion (Misc queries) | |||
| Cut / Paste with a Twist | Excel Discussion (Misc queries) | |||
| Large() with twist | Excel Worksheet Functions | |||
Linear Mode
