Hi,
Am trying to do the following, I know the logic in my head but cant get a formula to do the same thing.
Have a value in a cell, say X, I want the forumla to examine that number and if the number is less than a value of 1200 I want it to add 800 to the X value and give me a total ie X+800.
In addition if X is greater than 1200 then I want it to calculate the difference between 2000 and X and give me that value, leaving the value of 2000 in my calculation cell but telling me what the difference was in another cell
ie if X was 1700 in this example then the figure is 2000 in the cell with 300 being the difference.
Any thoughts?
Am trying to do the following, I know the logic in my head but cant get a formula to do the same thing.
Have a value in a cell, say X, I want the forumla to examine that number and if the number is less than a value of 1200 I want it to add 800 to the X value and give me a total ie X+800.
In addition if X is greater than 1200 then I want it to calculate the difference between 2000 and X and give me that value, leaving the value of 2000 in my calculation cell but telling me what the difference was in another cell
ie if X was 1700 in this example then the figure is 2000 in the cell with 300 being the difference.
Any thoughts?
