Hi

I have just discovered this Forum and I am hoping somebody can help me out.

I am trying to work out the following.

I have three cells. One cell will offer me a number multiplied by 1.3333 - the result will come from the activation of two other cells.

So if cell 2 has a number placed into it like 4 i would like a roundup of 6 to be in cell 1, if cell 2 has 0 in it i would like it to be inactive and draw the result from cell 3. The same if cell 3 has a number, it will activate cell 1. If both cells 2 and 3 have 0 in then neither are activated.

Does that make sense?

I have tried putting two roundup formulas in side by side with an IF or an AND in but my calculations keeps showing an error. But this was just a guess.

Hope someone can help

Thanks

Paul