"IF" or conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1786334%22%20slang%3D%22en-US%22%3E%22IF%22%20or%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786334%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20E46%20name%20formatted%20to%20a%20value%20of%20three.%20I%20want%20to%20get%20E47%20to%20be%20the%20formula%20of%20D47%20multiplied%20by%20the%20E46%20name%20format%20of%20three%20but%20only%20if%20D47%20is%20a%20negative%20number%20AND%20D48%20is%20a%20positive%20number.%20I%20have%20had%20slight%20success%20in%20getting%20it%20to%20work%20for%20an%20IF%20formatting%20if%20I%20choose%20one%20of%20the%20cells%20as%20the%20value%20but%20can%20not%20figure%20out%20how%20to%20have%20both%20values%20as%20a%20qualifier.%20I'm%20sure%20if%20someone%20can%20answer%20this%20my%20next%20question%20should%20be%20simple.%20Cell%20D46%20will%20be%20a%20negative%20but%20I%20want%20the%20answer%20in%20E46%20to%20be%20a%20positive%20number%20(It's%20points%20for%20a%20contest%20where%20that%20factor%20is%20better%20if%20it%20is%20a%20negative%20in%20D46%20but%20I%20will%20be%20using%20the%20same%20name%20formatting%20in%20E46%20to%20multiply%20another%20factor%20that%20will%20be%20a%20positive%20number.%20If%20I%20need%20to%20add%20other%20cells%20to%20format%20and%20reference%20I%20will%20be%20happy%20to%20do%20that%20I%20just%20need%20to%20know%20the%20way%20to%20get%20the%20initial%20%22IF%22%20formatting%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Race%2020%20sheet.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227070i445FD042495CA12C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Race%2020%20sheet.png%22%20alt%3D%22Race%2020%20sheet.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1786334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1786380%22%20slang%3D%22en-US%22%3ERe%3A%20%22IF%22%20or%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834168%22%20target%3D%22_blank%22%3E%40mmatulich%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20know%20what%20do%20you%20mean%20under%20%22%3CSPAN%3Ename%20format%20of%20three%22%2C%20but%20the%20idea%20of%20the%20formula%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(%20(D47%26lt%3B0)*(D48%26gt%3B0)%2C%20%22cslculation%20here%22%2C%20%22no%20result%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have E46 name formatted to a value of three. I want to get E47 to be the formula of D47 multiplied by the E46 name format of three but only if D47 is a negative number AND D48 is a positive number. I have had slight success in getting it to work for an IF formatting if I choose one of the cells as the value but can not figure out how to have both values as a qualifier. I'm sure if someone can answer this my next question should be simple. Cell D46 will be a negative but I want the answer in E46 to be a positive number (It's points for a contest where that factor is better if it is a negative in D46 but I will be using the same name formatting in E46 to multiply another factor that will be a positive number. If I need to add other cells to format and reference I will be happy to do that I just need to know the way to get the initial "IF" formatting  

 

Race 20 sheet.png

1 Reply
Highlighted

@mmatulich 

I don't know what do you mean under "name format of three", but the idea of the formula

=IF( (D47<0)*(D48>0), "cslculation here", "no result")