Formula Help

[Frick]

I have 3 col's each for different currencies


a1 = Curr 1 B1 = Curr 2 C1 = Curr3
a2 = rate 1 b2 = rate 2 c2 = rate3


In rows 5 through 15, I input numbers for cost in the currency
reflected rate.

I can write a simple formula that will convert the input cell to the
other exchanges but what I would like toknow is if there is a
condition that basically says for example in cell a6, if a6 is 0 and
b6 >0 then b6 times the exchange, or if a6 is 0 and c6 >0 then c6
times the exchange into a6.

Can this be done so that i don't have to keep copying a formula when
one is overwritten. I want to set this worksheet up as a template so
that when data can be entered at any time and the conversions are done
without having to recopy formula each time the sheet is cleared.

Thanks

 

[J.E. McGimpsey]

See one anwer as a reply to your other post.