Hi,
Have a problem trying to get a formula to work.
I am trying to set a scorecard up where it will give points depending on the % actual.
For example:
if less than 60%, then 0,
if equal to or greater than 60% but less than 75%, then 1
if equal to greater than 75% but less than 80%, then 2 and so on.
I have been playing around with the example below, but can't seem to get it working.
[php]=IF(A1<60%,0,IF(A1>A1<75%,1,))[php]
Maybe it 's because I pickled my brains last night.
Cheers,
Daywalker
Bookmarks