Rounding in an "IF" funciton

[Tollyseven]

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"?

[jeffreybrown]

Not all that sure why you would want to round if you're returning greater than and less than.

Do you have some samples of what's in G4 and H4?

[Jonmo1]

Try

=CHOOSE(SIGN(ROUND(H4,2)-ROUND(G4,2))+2,"Below","On","Above")&" Target"

Change the 2 2's to your desired level of rounding accuracy.

[amy_d2]

or you can use, this will the number

=IF(ROUND(H4,0)>ROUND(G4,0),"Above Target",IF(ROUND(H4,0)<ROUND(G4,0),"Below Target",IF(ROUND(H4,0)=ROUND(G4,0),"On Target")))

[Tollyseven]

Thanks All! amy_d2 your function work perfect. Thanks so much for the help.

[amy_d2]

Hi Tollyseven,

do not forget to mark thread as solved