Activate sum if other cell reach a number or above

[markxl111]

Hi.

Can some one help me with a sum please?

I have a cell(A1) that I want to read £0 until 'another cell(B1)' reaches set value or above.
When this 'other cell(B1)' reach a this set value or above I would like the sum £3.05*52 to activate in original cell(A1).

thanks
Mark

[Pete_UK]

What is the set value? Substitute that in the following formula in A1:

=IF(B1>=set_value,3.05*52,"")

Format as Currency to show the £ sign.

Hope this helps.

Pete

[markxl111]

HI Pete.

entered the sum: =IF(J127>=6475,3.05*52,"") which works a treat.
However when the sum isn't active the cell is black, is there a way of making it read £0.

thasnks
mark

[Pete_UK]

Just change the "" at the end of the formula to zero:

=IF(J127>=6475,3.05*52,0)

Hope this helps.

Pete

[markxl111]

thanks works perfectly

[Pete_UK]

Glad to hear it, and thanks for marking the thread as Solved.

As you are relatively new to the forum, you might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete