SOLVED

creating a semi-simple formula in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-3396669%22%20slang%3D%22en-US%22%3Ecreating%20a%20semi-simple%20formula%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3396669%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%203%20columns.%3C%2FP%3E%3CP%3EColumn%20A%20(hourly%20rate)%3C%2FP%3E%3CP%3EColumn%20B%20(weekly%20rate)%3C%2FP%3E%3CP%3EColumn%20C%20(daily%20total)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20create%20formula%20in%20column%20C%20so%20that%20it%20calculates%20a%20total%20differently%20depending%20on%20whether%20there%20is%20an%20amount%20in%20column%20A%20vs%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%3A%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20column%20A%20has%20an%20amount%20in%20it%2C%20then%20I%20want%20column%20C%20to%20calculate%20a%20formula%20to%20tally%20what's%20in%20column%20A*8.%3C%2FP%3E%3CP%3Eif%20column%20B%20has%20an%20amount%20in%20it%2C%20then%20I%20want%20column%20C%20to%20calculate%20a%20formula%20to%20tally%20what's%20in%20column%20B%2F5.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3396669%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3397095%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20semi-simple%20formula%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3397095%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1394070%22%20target%3D%22_blank%22%3E%40salpyapple%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20simply%20try%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(A2%26lt%3B%26gt%3B%22%22%2CA2*8%2CIF(B2%26lt%3B%26gt%3B%22%22%2CB2%2F5%2C%22%22))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3401294%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20semi-simple%20formula%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3401294%22%20slang%3D%22en-US%22%3Ethank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3403466%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20semi-simple%20formula%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3403466%22%20slang%3D%22en-US%22%3EYou're%20welcome!%3C%2FLINGO-BODY%3E
New Contributor

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.

 

 

3 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@salpyapple 

 

You may simply try this...

 

=IF(A2<>"",A2*8,IF(B2<>"",B2/5,""))
thank you
You're welcome!