Formula Query

[Mando1]

Hi there, hope someone can help...

The names of the worksheets are irrelevant, however I'm keen to know what the following means in plain English. Specifically around the comma?

=AND($J$14>'Project Sold Effort'!$AI$40,$J$14<='£ Calculations (Ref Only)'!$I$4)

Thanks

 

[wideboydixon]

It's a logical test to see if:

- The value in J14 is greater than the value in AI40 on sheet 'Project Sold Effort'
AND
- The value in J14 is less than or equal to the value in I4 on sheet '£ Calculations (Ref Only)'

WBD

 

[Mando1]

Great, thanks

It's a logical test to see if:

- The value in J14 is greater than the value in AI40 on sheet 'Project Sold Effort'
AND
- The value in J14 is less than or equal to the value in I4 on sheet '£ Calculations (Ref Only)'

WBD