Forum Discussion

lewisreiddd's avatar
lewisreiddd
Copper Contributor
Jun 02, 2020

Formula in Excel

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! 

 

 

excel
Formulas and Functions

1 Reply

  • Jose_Novaes's avatar
    Jose_Novaes
    Copper Contributor
    Jun 02, 2020

    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

     

Resources