I can't get the following IF statement to produce the desires results. Result comes up blank.
=IF(B3="168375","500","")
Cell A3 = 168375 so am i missing something that is preventing this statement from resulting in 500 being displayed in cell B3 instead of a blank cell.