if formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1497655%22%20slang%3D%22en-US%22%3Eif%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497655%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20been%20stuck%20on%20working%20out%20the%20formula%20for%20the%20below%3C%2FP%3E%3CP%3Ethis%20is%20what%20I%20have%20and%20it%20isnt%20working!%20HELP%20pls!!%3C%2FP%3E%3CP%3E%3DIF(Sales%26gt%3B%3DTarget%2CSales*Bonus_rate)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497660%22%20slang%3D%22en-US%22%3ERe%3A%20if%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497660%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713973%22%20target%3D%22_blank%22%3E%40MelB2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20try%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20D8%3C%2FP%3E%3CP%3E%3DIF(C8%26gt%3BTarget%2CC8*Bonus_rate%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20then%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497803%22%20slang%3D%22en-US%22%3ERe%3A%20if%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713973%22%20target%3D%22_blank%22%3E%40MelB2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENamed%20range%20Sales%20starts%20from%20the%20header%2C%20thus%20an%20error%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20320px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202107i092F694EDCEE00AA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20start%20start%20it%20from%20row%20%238%20it's%20more%20correct%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20288px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202108iAB5DC3D845E1DEEC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAnd%20if%20correct%20formula%20a%20bit%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(Sales%26gt%3B%3DTarget%2CSales*Bonus_rate%2C)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Ewhen%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20309px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202110i0D89F21A16250D83%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, I have been stuck on working out the formula for the below

this is what I have and it isnt working! HELP pls!!

=IF(Sales>=Target,Sales*Bonus_rate)

2 Replies
Highlighted

@MelB2020 

Please try this...

 

In D8

=IF(C8>Target,C8*Bonus_rate,0)

 

and then copy it down.

Highlighted

@MelB2020 

Named range Sales starts from the header, thus an error

image.png

If start start it from row #8 it's more correct

image.png

And if correct formula a bit

=IF(Sales>=Target,Sales*Bonus_rate,)

when

image.png