IF function

[Big_guy]

Hi

I am having a problem. I need the following If formula to work for me.

The scenerio: A building having a GFA greater than 250 and less than 1500 must have its parking measured at 1 space/28m2.

Therefore I need the following function (which I have apparantly not written the right syntax for)
F20 is the final GFA cell

If(2501500, F20/G27,"") This works for GFA area over 250m2, however it doesnt shut off when I reach 1500m2 floor area. I have another cell that does the over 1500m2 calculation so I need this one to blank out after 1500m2. Sorry if this is confusing. I hope you understand what I'm trying to explain.

Thanks for any help
Larry (Big_guy)

[eliW]

On 2002-03-23 22:15, Big_guy wrote:
Hi

I am having a problem. I need the following If formula to work for me.

The scenerio: A building having a GFA greater than 250 and less than 1500 must have its parking measured at 1 space/28m2.

Therefore I need the following function (which I have apparantly not written the right syntax for)
F20 is the final GFA cell

If(2501500, F20/G27,"") This works for GFA area over 250m2, however it doesnt shut off when I reach 1500m2 floor area. I have another cell that does the over 1500m2 calculation so I need this one to blank out after 1500m2. Sorry if this is confusing. I hope you understand what I'm trying to explain.

Thanks for any help
Larry (Big_guy)

Larry, try this:
=IF(AND(F20>250,F20<1500),F20/G27,"")
Eli

[Big_guy]

Thanks so much for your help Eli. I was trying to get that to work for 3 hours last night. Man I really appreciate you assistance Everything is working perfectly now.

Take care.

Larry