May 18 2022 03:46 PM
I have 3 columns.
Column A (hourly rate)
Column B (weekly rate)
Column C (daily total)
How do I create formula in column C so that it calculates a total differently depending on whether there is an amount in column A vs column B.
for example:
if column A has an amount in it, then I want column C to calculate a formula to tally what's in column A*8.
if column B has an amount in it, then I want column C to calculate a formula to tally what's in column B/5.
May 18 2022 06:31 PM
SolutionMay 18 2022 06:31 PM
Solution
You may simply try this...
=IF(A2<>"",A2*8,IF(B2<>"",B2/5,""))