Hi Guys,
I'm using this formula in attendance sheet & need to add a condition.
=H8+I8/60+K8
I want K8 to be added in the end only if H8 value is greater than 11
Someone please help.
Regards
Andy
Hi Guys,
I'm using this formula in attendance sheet & need to add a condition.
=H8+I8/60+K8
I want K8 to be added in the end only if H8 value is greater than 11
Someone please help.
Regards
Andy
Last edited by andyzz; 07-17-2014 at 09:11 PM.
Hi
Try thisIf this solves your problem, please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanksFormula:Please Login or Register to view this content.
Thanks a lot, it worked! Great
No worries. Please don't forget to click on the * next to my post to say thanks
I'm unable to see any thanks button but I've added to reputation. thnx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks