Thread: Create a conditional formula that results in another calculation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dyrret dyrret is offline
external usenet poster
  
Posts: 5
Default Create a conditional formula that results in another calculation
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

Reply With QuoteReply With Quote