If Statement Gives Blank Results
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.
It seems that your problem is comparing numbers and texts. If A3 contains a number (168375), you cannot use quotation marks. Quotation marks are for texts.
Your formula should be in B3:
=IF(A3=168375,500,"")