| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF functions
I am trying to get a results for a score. for example in cell A, the cell
(which is the results) shows as 5; I need cell B to tell me that if the value in cell A is less than or equal to 2, leave cell blank, if the value in cell B is between 3 to 4 result MONITOR PERFORMANCE and if the result is equal to 5 and above results to show REQUIRE COACHING A - 5 B - =IF(A<=2,"",IF(a3,"Monitor Performance",IF(a5,"Require Coaching!"))) How come the result I got in B is 'Monitoring Performance', is my formula wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| multiple functions | Excel Worksheet Functions | |||
| Multiple if functions with sum | Excel Worksheet Functions | |||
| Multiple Functions | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
![Jafferi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
