Jun 02 2020 03:57 AM
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!
Jun 02 2020 05:17 AM
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