Forum Discussion

ahmad ali's avatar
ahmad ali
Brass Contributor
Nov 14, 2018
Solved

IF statement with 2 cells

Hello,   could you please tell me if a statement like this ( IF(B1="F";C1="Failed" ;else C1="not failed") is possible? if yes ,could you please give me the formula   please see the attached    ...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 14, 2018

    When it's not a formula, it will be some macro. Formula returns the value into its own cell

ahmad ali's avatar
ahmad ali
Brass Contributor
Nov 14, 2018

Hi Sergei,

 

No .. in D1

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 14, 2018

When it's not a formula, it will be some macro. Formula returns the value into its own cell

Resources