| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2016 IF function wrong answer
Hi, I'm confounded by excel's answer to my if function. My formula worked for column G. But in that column my condition was not = but just =. When I tried to apply the same sequence of formula, it now gives the first answer "99+" even if the condition is not met =If(f2=141,"99+",if(blah blah blah)). Can anyone help? Thanks
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cosine Function Returns Wrong Answer! | Excel Discussion (Misc queries) | |||
| Cannot drag Excel 365 (2016) window | Excel Discussion (Misc queries) | |||
| Getting wrong answer with Match Function | Excel Worksheet Functions | |||
| Using Indirect in a Sumif Function returns the wrong answer | Excel Discussion (Misc queries) | |||
| Wrong answer after using the payment formula in excel | New Users to Excel | |||
Linear Mode
