Formula help

S

SoggyCashew

Hello I have this formula that works so far but I need to divide the D9 by K9
and cant figure out the formula... Here is what I have so far but get the div
error.
=IF( C9=0, 0, C9+1)*D9/K9
 
S

SoggyCashew

sorry I wanted to * by K9 and im getting the wrong number? here is what I got
so far but its giving me the wrong number when I times it by K9
=IF( C9=0, 0, C9+1*D9)*K9
 
R

Rick Rothstein

Well, you shouldn't be getting the "div error" then... perhaps if you give
us the numbers you have in the cells in your formula and the answer that
your formula is giving you, along with the answer you think it should be
giving you, then would have something to work with in trying to solve your
problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
The sum of the same function that is used for a range of cells 2
formula for spreadsheet, avoiding zeros? 5
Trying to combine formulas 0
Hlookup and sum formula 3
formula to work from data column 1
Countif, index and match 2
Help - hiding multiple sets of rows based on two different cells 2

Top