We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Rewrite excel formula to a php statement

dennis231
dennis231 asked
on
Medium Priority
649 Views
Last Modified: 2012-05-06
Hi,
I am trying to write a php statement which come from a excel formula.
I was trying to figure out how to do the MOD in php, but I didn't know how to do it correctly. Thanks for your help.



= intval ($total)+( intval (MOD($total,1)/0.3))+(SUM(MOD($total,1))-( intval (MOD($total ,1)/0.3))*0.3)

Open in new window

Comment
Watch Question

Web Developer, specialising in WordPress
CERTIFIED EXPERT
Most Valuable Expert 2011
Commented:
Mod in php is done with a % sign.

Eg
10 % 3
Should return 1

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Terry WoodsWeb Developer, specialising in WordPress
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.