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,