Excel 2016 IF function wrong answer
1 Attachment(s)
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
|
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com