I would like to return a text result based on the following but cannot quite get it right
If H14=0 then I14= “achieved Target”
If H14<0 then I14= “under target”
If H14>0 then I14= “over target”
Thanks in advance
I would like to return a text result based on the following but cannot quite get it right
If H14=0 then I14= “achieved Target”
If H14<0 then I14= “under target”
If H14>0 then I14= “over target”
Thanks in advance
In I14, enter:
=If(H14=0,"achieved Target",if(H14<0,"under target","over target"))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I tried entering a couple of times and it doesnt quite work for the =0 bit. Forgot to say that H14 contains a formula to add the value of others cells, could this be affecting things?
Yes, if the result is not exactly 0, then it won't work...
you can try perhaps rounding H14 to 0 decimals...
try: =If(ROUND(H14,0)=0,"achieved Target",if(H14<0,"under target","over target"))
...but I am not sure that will give the results you want.. what do you really mean by H14<0 and H14>0... do you mean like 1, 2, -1, -2.. because if you mean 0.01, -0.04, etc... it might not work.
Last edited by NBVC; 06-25-2008 at 01:53 PM.
works fine - thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks