Hi!

Try this:

=IF(SUM(AC215:AC250,AC252,AC255,B20:B25,B30)*G55/J55*(M55/12)<K55,K55,SUM(AC215:AC250,AC252,AC255,B20:B25,B3 0)*G55/J55*(M55/12))

OR, use an intermediate cell to hold:

A1 =SUM(AC215:AC250,AC252,AC255,B20:B25,B30)

Then:

=IF(A1*G55/J55*(M55/12)<K55,K55,A1*G55/J55*(M55/12))

Biff

"jackie" wrote in message
...
Please help me this formula is driving me nuts. I am trying to add
multiple
ranges of fields, then taking the total and multiply by tenant square
footage, then divide by gross leasable area, then take that total and
multiply by an admin fee......NOT DONE YET.....then take that total and
check
it with an if statement....is this total <K55 if so enter the total, if
false
enter the value from field K55. So far this has stumped multiple IT
personnel...PLEASE HELP! Here's an example of the formula:

=-(sum(AC$215:AC$250+AC$252+AC$255)+(SUM B20:25+B30)*G55/J55*M55/12),
if(<k55,[sum of above],[k55])

Thanks,