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(250<F20>1500, 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)
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(250<F20>1500, 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)