I am trying to calculate a column to read if column E3 is greater than 0 I want to times this value in column E4 by .03 percent to come up with a total commission allowance. Can this be done?

Thank you

I'm assuming you're talking about Microsoft Excel? Because you didn't really give us too much information. If that's true, try this:

=If(E3>0,E4*.03,"")Law of Logical Argument: Anything is possible if you don't know what you're talking about.

Of course, if you are using some other spreadsheet program then the excel suggestion might not work. We have no way to tell what you are using unless you tell us.

Alwayspop back and let us know the outcome - thanks

Ask Your Question

Weekly Poll