I'm still not clear on what you're trying to accomplish.

What cell do you want this to go into? If M7, then do you really want
circular references if G10 or G11 <0?

What should happen if *both* G10 and G11 are <0?

The IF() function has the form

=IF(condition, TRUE branch, FALSE branch)

i.e., in =IF(G100, ..., ...), G10 is either 0 or it's not. Adding the
additional terms is why you got the error.


In article ,
izzie wrote:

Yeah, sorry, I didn't explain myself properly. I do need M7 to change
once the other fields have been updated according to that equation. How
do I use an event macro?

Originally, what I did was this:

=IF(G100, M7+G10-M7*G10, M7+G10+M7*G10, IF(G110, M7+G11-M7*G11,
M7+G11+M7*G11, G7*0.5))

and it said I had to many arguments.