View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default



John C. Harris, MPA wrote:
....
So, In english:

If the FCAT score is blank, compare the Stanine score to the converted
Stanine score. If it is not blank, then compare the FCAT score to the
Converted FCAT score.

The current formula is: =IF(E4=C4,"Improved","No")
I need to add the ISBLANK statement in front first so that
IF E4 ISBLANK, then run =IF(G4=D4, "Improved","No") else =IF
(E4=C4,"Improved","No")


=IF(ISBLANK(E4),IF(G4=D4, "Improved","No"),IF(E4=C4,"Improved","No"))