Formula in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1433037%22%20slang%3D%22en-US%22%3EFormula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433037%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20get%20my%20head%20around%20this%20formula%2C%20I%20think%20I've%20been%20staring%20at%20it%20for%20too%20long%20now.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20my%20formula%20to%20look%20at%20cell%20P23%2C%20if%20P23%3D6%2C%20then%20display%206%20in%20cell%20N23.%20If%20P23%20doesn't%20%3D6%2C%20then%20follow%20this%20formula%3A%20%3CFONT%3E%3DIFERROR(Progress!E25*Progress!C25%2C0)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ECan%20anyone%20help%3F%26nbsp%3B%3CFONT%3E%3CBR%20%2F%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%26nbsp%3B%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-1433037%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-1433185%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433185%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F674965%22%20target%3D%22_blank%22%3E%40lewisreiddd%3C%2FA%3E%26nbsp%3Bnot%20exactly%20sure%20what%20you%20trying%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it%20seems%20a%20case%20of%20use%20only%201IF%20condition%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(P23%3D6%2C6%2CProgress!E25*Progress!C25)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20P23%20is%20equal%20to%206%20display%206%20if%20not%20Calculate%26nbsp%3BProgress!E25*Progress!C25%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EHope%20this%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I can't get my head around this formula, I think I've been staring at it for too long now. 

 

I want my formula to look at cell P23, if P23=6, then display 6 in cell N23. If P23 doesn't =6, then follow this formula: =IFERROR(Progress!E25*Progress!C25,0)


Can anyone help? 

 

Thanks! 

 

 

1 Reply
Highlighted

Hi @lewisreiddd not exactly sure what you trying here

 

But it seems a case of use only 1IF condition

 

=IF(P23=6,6,Progress!E25*Progress!C25)

 

So if P23 is equal to 6 display 6 if not Calculate Progress!E25*Progress!C25

Hope this helps