Formula design

S

Syd

I need to be able to substract a value in cell's D11 if the value in D11 is greater than 0/null, if D11's value is = X from the Value listed in cell H2, and the value of cell D12 is to be substracted from the value in cell C11 if the value in D12 is also =x, if not, plug in a zero/null into the formula. See current formula in the first row below and conditional values in the second row below.

Current formula: =D71+((C8-C7)*24*60)-H2-C11

Conditional cell values for: D11 = x and D12 = x

Hopefuly, I've explained myself well enough here.
 
J

Jonathan Rynd

Hopefuly, I've explained myself well enough here.

Unfortunately, I couldn't figure out what you were saying. What do you
mean by "subtract a value in cell D1"? Do you mean you want to change the
formula that is in cell D1?

When you say "Current formula", what cell is it the current formula for?

When you day "D11 = x and D12 = x", do you mean that each of those cells
contains the string "x"?

What do you mean by "plug a zero/null into the formula"? What formula? How
is a zero/null supposed to be "plugged in"?

It would really help if you were more specific. Say what's in each cell
right now, and say what you want for each cell.
 

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

Top