| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i want to create an IF formula to bring back one of four results . | Excel Worksheet Functions | |||
| Calculation results as static data not formula. | Excel Worksheet Functions | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
| create time calculation formula | Excel Discussion (Misc queries) | |||
| create a conditional formula | Excel Worksheet Functions | |||
Threaded Mode
