jeudi 4 janvier 2018

Additional formula needed in IF statement

I currently have a large nested IF statement that uses a helper cell (C1) to dictate which formula to utilize based on numbers 1,2,3,5 & 6. Specifically, one IF statement within the larger nested IF statement needs to be updated for instances when there is a blank cell in column A. Here is how my workbook is setup:

  1. Data Tab Data Tab
  2. Bonus Tab enter image description here
  3. Summary Tab

enter image description here

This is my current formula in Column B:

=IF(Data!$C$1=2,IF(SUM(Bonus!B2:C2)<1,0,1)*Data!$B$3+Data!$B$2)

What I am looking for is when cells in column A are blank, than the corresponding cell in Column B would be 0. Again, the formula above has to remain in the =IF(Data!$C$1=2, format since it is part of a larger nested IF statement.

Answer I am seeking:

enter image description here

Thank you for looking!

Aucun commentaire:

Enregistrer un commentaire