| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wrong output returned during IF function
I currently have
=IF(O2="","",(VLOOKUP(O2,risk_impacts!B2:BV95,72,F ALSE))) Which is returning the correct value of 14 In a different cell I have the following formula based on the value of the above cell. =IF(M5<=3,"Green",IF(M5=20,"RED","AMBER")) Yet the outcome is showing as "RED" when it's clearly "AMBER". This was in response of conditional formatting not working. As I'm using 2007 I can place 3 separate formatting options on the one cell and yet it was still not working and was showing always as red. PLEASE HELP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Averages/Sums of values returned from IF function | Excel Discussion (Misc queries) | |||
| How do I set a minimum value to be returned from IF function | Excel Discussion (Misc queries) | |||
| Querying a range returned by another function | Excel Worksheet Functions | |||
| Format numbers returned in the function CONCATENATE | Excel Discussion (Misc queries) | |||
| Using the returned value of a function | New Users to Excel | |||
Threaded Mode
