Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,195,008 members, 7,956,729 topics. Date: Monday, 23 September 2024 at 05:35 PM

Please Help Me Decode This Excel Formular!! - Career - Nairaland

Nairaland Forum / Nairaland / General / Career / Please Help Me Decode This Excel Formular!! (531 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"wink*cool).

1 Like

Re: Please Help Me Decode This Excel Formular!! by odimbannamdi(m): 8:42am On May 19, 2016
unofficial:
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"wink*cool).

thanks bro

(1) (Reply)

Vacancy For Account Clerk With Knowledgeof Peachtree. / ki / Vacancy

(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. 9
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.