Activating one cell with a number if one of two cells has an entry/number in it.

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

Hi Olly

That is great, it worked a treat - thank you, if only I had asked one and a half hours ago! If i wanted to remove the Roundup is it okay to just delete that or would the whole formula need revising?

Thanks once again.

Paul

Hi Olly

You have opened a can of worms for me here.

This is my final question of the day. Using the above formula, without roundup, can a variable be inserted so that cell A1 chooses the lower of the two figures produced in cell B1 and C1?

i.e.

A1 B1 C1
5 5 6

or

A1 B1 C1
5 7 5

Can it be shown that if B1 is the lowest number that the figure is TRUE as well? Or is that beyond the world of excel?

i.e.

A1 B1 C1 D1
TRUE 5 5 6

and such the result if D1 were lower FALSE?





Thanks

Paul

I was trying to combine the two if possible. But that has come in very handy. I think I need to buy an Excel Bible.

Hi

I think this explains it. I am trying to get a sheet where it calculates using the lowest figure instead of me checking everything 100 times.

Thanks

Paul

excelhelp.xlsx

Fantastic thank you very much!!!