Hi All ~
I am new to the forum and I have a quesiton about rounding in an "IF" funciton. I am using the following function:
=IF(H4>G4,"Above Target",IF(H4<G4,"Below Target",IF(H4=G4,"On Target")))
The function looks to be working, but I noticed that some of my cells equal, but the function is returning either Above or Below Target. I am guessing this is due to rounding. Anyone know how to correct this so the funciton will return "On Target"?
Bookmarks