Multiple if's logic help please.

[#1]

I need to put the below logic together.How can I do that please ?

Building ID	Occupancy Count	Building Capacity	Occupancy Count (manual)	Building Capacity (manual)
THOM-B0843	0	2	0	0
BUCHAREST	0	1	0	0
THOM-B5661	0	256	0	0
BLACKWALL	0	1	0	0
THOM-B0150-M	0	2	0	0
THOM-B5631	0	35	0	0
KUWAIT	0	14	0	0
THOM-B4032	0	6	0	0
THOM-B5262	0	96	0	0
SAUCES	0	22	0	0
THOM-1234	0	34	67	100
THOM-3218	0	45	67	108

if ([Occupancy count] =0 ,

   if([Building Capacity] > 1 , sum([Building Capacity(Manual)]

the tricky part is if the first rule is true and

if([Building Capacity(Manual)] =0 ,

if([Occupancy Count(Manual)]=0,sum([Building Capacity]

Thanks much,

Alva

[amayuresh]

Do you want expression like this

=if ([Occupancy Count]=0 and [Building Capacity (manual)] =0 and [Occupancy Count (manual)]=0,sum([Building Capacity]),

if ([Occupancy Count] <>0 and [Building Capacity] > 1 , sum([Building Capacity (manual)])))

or can elaborate your requirement more with example

[ahammadshafi]

Hi Pavana:

May be this will work

If([Occupancy Count]=0 and [Building Capacity(Manual)] = 0 and [Occupancy Count(Manual)] = 0, Sum([Building Capacity]),

If ([Occupancy Count]=0 and [Building Capacity]>1), Sum([Building Capacity(Manual)]))

[ahammadshafi]

Hi Pavana:

You can try this if the first one doesn't work

If([Occupancy Count]=0 and [Building Capacity(Manual)] = 0 and [Occupancy Count(Manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),

If ([Occupancy Count]=0 and [Building Capacity]>1), Sum([Building Capacity(Manual)])

[amayuresh]

there few brackets are missing. Check this now,

=If([Occupancy Count]=0 and [Building Capacity (manual)] = 0 and [Occupancy Count (manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),

If([Occupancy Count]=0 and [Building Capacity]>1, Sum([Building Capacity (manual)])))

This works for me.

[ahammadshafi]

Many thanks Mayuresh.

Apologies for the mistake. Just copying from Mayuresh:

=If([Occupancy Count]=0 and [Building Capacity (manual)] = 0 and [Occupancy Count (manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),

If([Occupancy Count]=0 and [Building Capacity]>1, Sum([Building Capacity (manual)])))

[avinashelite]

Try like this

if ([Occupancy count] =0 and [Building Capacity] > 1 and [Building Capacity(Manual)] =0 and [Occupancy Count(Manual)]=0, sum([Building Capacity(Manual)],

if([Building Capacity(Manual)] =0 and [Occupancy Count(Manual)]=0,sum([Building Capacity]

)

)