ExcelBanter - Functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Functions (https://www.excelbanter.com/excel-worksheet-functions/7755-functions.html)

office type

Functions

how do i get multiple functions to compute one answer, i.e. when i want any
number less than 4000 to compute function A and numbers greater than 4000 to
compute function B ext. ext.

JE McGimpsey

One way:

=IF(A1<4000,<your function A here, IF(A14000, <your function B
here, "Exactly 4000"))

In article ,
"office type" <office type @discussions.microsoft.com wrote:

how do i get multiple functions to compute one answer, i.e. when i want any
number less than 4000 to compute function A and numbers greater than 4000 to
compute function B ext. ext.

All times are GMT +1. The time now is 03:04 PM.