excel 2010 - if/and formula

hi experts, please assist with the following formula

this formula to be shown in cell ref "s14"

= if q14 and r14 = either 0 (zero) or nothing, show nothing, otherwise if q14 has a value then roundup the value in p14 by the value in q14, or if r14 has a value then rounddown the value in p14 by the value in r14
Frank .SBuilding EstimatorAsked:
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

Please try


You haven't mentioned the possibility of both Q14 and R14 having values

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.