"if" with 3 conditions

[KnightShift]

I can't seem to find a reliable calculation for obtaining numerical information for three "true" conditions.

The conditions are this:

if[input date = search date]

and

if[field1 = "nc"]

and

if[field2 = "something"]

then return

the sum of fields 4 + 5

-

Right now I am having to use a script to return these results, but given the fields that the script is working in have 40 repeating cells, I don't think I'm using the cleanest solution.

Any suggestions??

Thanks

[-Queue-]

Do you mean something like

Case( field1 = "nc" and field2 = "something", field4 + field5 )

?

If all the referenced fields are repeating and the resulting calculation field is repeating, then it should return the appropriate result for each repetition.

[KnightShift]

Not exactly. There is the date factor to add in, that's where the calculation loses its ability to run correctly. There are 3 items that must be 'true' to get the info. Date=date,nc=nc,field2=something.

Do you mean something like

Case( field1 = "nc" and field2 = "something", field4 + field5 )

?

If all the referenced fields are repeating and the resulting calculation field is repeating, then it should return the appropriate result for each repetition.

[-Queue-]

Oops! What I meant was

Case( inputdate = searchdate and field1 = "nc" and field2 = "something", field4 + field5 )