Microsoft Office Forums - View Single Post - [Solved] Need a little help with an if statement

Thread: [Solved] Need a little help with an if statement

View Single Post

Old

04-07-2015, 05:12 AM

cangelis

cangelis is offline

cangelis uses Windows 7 64bit

Windows 7 64bit cangelis uses Office 2010 64bit

cangelis uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jan 2014

Posts: 18

cangelis is on a distinguished road

Default

Sorry - my error. The if statement should be:

if the current column is greater than 9494 then the result should be zero. Oftentimes my total is higher than the 9494 and I end up with a negative percentage. I should not have a negative percentage.

Reply With Quote