Hi,

I'm new to all things Excel but have managed to get the correct result from my formula, However I need to cap the output between the range -7 and +7 e.g if the result is <-7 then change it to -7, If it's >7 change it to 7, Otherwise no change.

Thanks in advance for any help....