| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function problem,
Nasser Saadi wrote:
On Friday, September 13, 2019 at 4:49:08 PM UTC+3, annae wrote: I'm trying to calculate a maximum amount of value. That is, if a value is higher than 50000, it needs to display 50000. If not, display current value. A1=35678 B1 should display 35678 (that is, equal to A1) A1=67980 B1 should display 50000 B1 = IIf(A1 = 50000, 50000, A1) Formula in B1: =if(A150000,50000,A1) Just one "i" ;) -- Vie : n.f. maladie mortelle sexuellement transmissible Benoit chez lui à leraillez.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum function problem | New Users to Excel | |||
| Problem with = in function | Excel Worksheet Functions | |||
| Problem with Function | Excel Worksheet Functions | |||
| Mid Function Problem | Excel Discussion (Misc queries) | |||
| PC to MAC VBA function problem | Excel Programming | |||
Threaded Mode
