If function help

[bobbyC]

What I need is a way of adding 1 to a value in a cell if the value from another cell on a different work sheet is above or below a certain value; without any prior knowledge or experience of programming im basically trying to do the following...

IF L3:L3350>1800 then +1 to J50
IF L3:L3350<1800 then +1 to F50

What im trying to do is +1 to the value in cell J50 if SLA was breached (>1800)
If SLA was not breached (<1800) then +1 to the value in cell F50

Thank you in advance; I realise this isn't the most technically orientated or posed question but any help would be fantastic,

Many thanks,

BC

[Moo the Dog]

You can't change the value in other cells with formulas, you would need a macro (VBA) to do that.

- Moo

[bobbyC]

ah hah,

Thanks very much, I shall start researching directly

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.