Recalculate on condition

Is there a way to make excel recalculate a spreadsheet if a given condition is met/not met?

EG, =if(A1 ><1,"",recalculate)

I assume your worksheet is set to manual recalculation and that you meant that A1<>1 (Not equal to) below?

If so you can place this code in the Worksheet_Change event

Please Login or Register  to view this content.

Hope this helps!

Originally Posted by DavidObeid

Is there a way to make excel recalculate a spreadsheet if a given condition is met/not met?

EG, =if(A1 ><1,"",recalculate)

Thanks Excelenator,

I actually meant >= 1

The spreadsheet automatically calculates, but some values are user defined, some the result of formulae and some the result of a randomly generated number.

I don't know VBA, so can you give me idiot proof instructions as to how to implement the solution?

Sure thing.

1. Copy the code below
2. Right click on the sheet tab of the sheet containing your data
3. Select "View Code"
4. This will take you to the VBE (Visual Basic Editor)
5. You should see two drop down boxes towards the top of the screen
6. The one on the left says "General". Drop down and select "Worksheet"
7. Highlight the code that gets populated and right click and select Paste to paste in the code below.
8. Return to your worksheet

Now anytime the value of Cell A1 is >= 1 the worksheet will recalculate.

Please Login or Register  to view this content.