Please Help Me Decode This Excel Formular!! - Career - Nairaland
Nairaland Forum / Nairaland / General / Career / Please Help Me Decode This Excel Formular!! (532 Views)
Free Data Analysis with Ms Excel Training In Ikeja, Lagos, October, 2020. / Excel Thread: Post Your Spreadsheet Challenges (2) (3) (4)
(1) (Reply)
| Please Help Me Decode This Excel Formular!! by odimbannamdi(m): 4:30pm On May 18, 2016 |
Guys, please help me decode this formular: =IF(E3-G6<=0,1,IF(OR(D6="", E3="" ),"",D6/((E3-G6)* 8 ))) I also added the Excel workbook in which it is used. Thanks
|
| Re: Please Help Me Decode This Excel Formular!! by unofficial(m): 4:46pm On May 18, 2016 |
What do you mean by 'decode'? The formula is self explanatory na; or do you need someone to explain the formula? Modified. This should help If "approved days off" is greater than the "no of days", then "productivity=100%" Else If Either "HRS Booked" or "No of Days" is blank, "Productivity" should be blank Else Calculate this formula ("HRS Booked"/(("No of days" - "Approved days off"  * ).1 Like |
| Re: Please Help Me Decode This Excel Formular!! by odimbannamdi(m): 8:42am On May 19, 2016 |
unofficial: thanks bro |
(1) (Reply)
Professional Exam In Federal Government Job(ict) / Vacancy / After Work, Is What Determines Your Future!
(Go Up)
| Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7 |