Frank Bacchus
Member
Hi all:
In the attached Excel Sheet, there are a "Mileage" cell, a "Mileage Rate" cell and an "Amount" Cell. I want to use the "Amount" cell for dual purposes. I want to calculate the Mileage * Mileage Rate, placing the results in the "Amount" cell, only if the "Mileage" cell is populated. If the "Mileage" cell is not populated, I want to use the "Amount" cell to record any other amount (see uploaded file). Total Expenses (cell F4) is automatically calculated with the total amounts from the "Amount" cells. Thanks
frank
In the attached Excel Sheet, there are a "Mileage" cell, a "Mileage Rate" cell and an "Amount" Cell. I want to use the "Amount" cell for dual purposes. I want to calculate the Mileage * Mileage Rate, placing the results in the "Amount" cell, only if the "Mileage" cell is populated. If the "Mileage" cell is not populated, I want to use the "Amount" cell to record any other amount (see uploaded file). Total Expenses (cell F4) is automatically calculated with the total amounts from the "Amount" cells. Thanks
frank