Create a conditional formula that results in another calculati
Thankyou,
Works wonderfully and makes sense when I see it. I was trying to construct
something too complicated....missed the more straight forward answer.
dyrret
"T. Valko" wrote:
Try this:
=IF(COUNT(A2),A2/4.54,IF(COUNT(B2),B2*0.83,""))
--
Biff
Microsoft Excel MVP
"dyrret" wrote in message
...
I'm just learning to use Excel.
I want to enter data in either column A (litres) OR column B (US gallons).
Column C will convert to imperial gallons.
I would like to create a formula in column C that would result in this
logic:
IF there is data in cell "A(n)" then do calculation A(n)/4.54, if no data
in A(n) and there is data in cell "B(n)" then do calculation B(n)*.83
|