Can someone please help me with this function? I am trying to do a nested IF
function with three IF options (Circle, Triangle, Square).
I am trying to get Excel to automatically calculate an area (in sq ft) based
on its dimensions, broken up according to the shape of the room.

Rather than using multiple columns to do this, though, I want to consolidate
it into an easy-to-read form for the user, such that the "Shape" column is a
drop-down, validated to include Circle, Triangle, & Square. I want the "Area"
column to calculate the area of the space based on the shape selected. The
values for the formula dimensions will be captured in Length (FT & IN), Width
(FT & IN), and Radius (FT & IN).

This is the function that I've created, but it is giving me a general error.

=IF(A1="Circle€�,=(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",=(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",=((C9+D9/12)*(E9+F9/12))))

Any help regarding how to fix my formula would be greatly appreciated.

Thank you!
--
Diane

Just a few extra equal signs (as far as I can see)
=IF(A1="Circle",(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",((C9+D9/12)*(E9+F9/12))))
We could also remove some redundant parentheses
=IF(A1="Circle",PI()*((G9+H9/12)/2)^2,IF(A1="Triangle",(C9+D9/12)*(E9+F9/12)/2,IF(A1="Square",(C9+D9/12)*(E9+F9/12))))I would used one cell for each dimension and formatted it with # ?/12In this way I would type, for example, 4 4/12 for 4 feet and 3 inchesbest wishes--Bernard V LiengmeMicrosoft Excel MVPhttp://people.stfx.ca/bliengmeremove caps from email"Diane" wrote in ... Can someone please help me with this function? I am trying to do a nestedIF function with three IF options (Circle, Triangle, Square). I am trying to get Excel to automatically calculate an area (in sq ft)based on its dimensions, broken up according to the shape of the room. Rather than using multiple columns to do this, though, I want toconsolidate it into an easy-to-read form for the user, such that the "Shape" column isa drop-down, validated to include Circle, Triangle, & Square. I want the"Area" column to calculate the area of the space based on the shape selected. The values for the formula dimensions will be captured in Length (FT & IN),Width (FT & IN), and Radius (FT & IN). This is the function that I've created, but it is giving me a generalerror. =IF(A1="Circle",=(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",=(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",=((C9+D9/12)*(E9+F9/12)))) Any help regarding how to fix my formula would be greatly appreciated. Thank you! -- Diane

without looking deeply, what's wrong is the embedded "=" inside the formala.
There should be only 1 at the beginning:
=IF(A1="Circle",(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",((C9+D9/12)*(E9+F9/12))))

"Diane" wrote in message
...
Can someone please help me with this function? I am trying to do a nested
IF
function with three IF options (Circle, Triangle, Square).
I am trying to get Excel to automatically calculate an area (in sq ft)
based
on its dimensions, broken up according to the shape of the room.

Rather than using multiple columns to do this, though, I want to
consolidate
it into an easy-to-read form for the user, such that the "Shape" column is
a
drop-down, validated to include Circle, Triangle, & Square. I want the
"Area"
column to calculate the area of the space based on the shape selected. The
values for the formula dimensions will be captured in Length (FT & IN),
Width
(FT & IN), and Radius (FT & IN).

This is the function that I've created, but it is giving me a general
error.

=IF(A1="Circle",=(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",=(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",=((C9+D9/12)*(E9+F9/12))))

Any help regarding how to fix my formula would be greatly appreciated.

Thank you!
--
Diane

Hi,

you should just delete all equal sign (=) within your formula like below:

=IF(A1="Circle€�,(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",((C9+D9/12)*(E9+F9/12))))

if it helped please hit yes.

Thanks
--
Farhad Hodjat


"Diane" wrote:

Can someone please help me with this function? I am trying to do a nested IF
function with three IF options (Circle, Triangle, Square).
I am trying to get Excel to automatically calculate an area (in sq ft) based
on its dimensions, broken up according to the shape of the room.

Rather than using multiple columns to do this, though, I want to consolidate
it into an easy-to-read form for the user, such that the "Shape" column is a
drop-down, validated to include Circle, Triangle, & Square. I want the "Area"
column to calculate the area of the space based on the shape selected. The
values for the formula dimensions will be captured in Length (FT & IN), Width
(FT & IN), and Radius (FT & IN).

This is the function that I've created, but it is giving me a general error.

=IF(A1="Circle€�,=(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",=(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",=((C9+D9/12)*(E9+F9/12))))

Any help regarding how to fix my formula would be greatly appreciated.

Thank you!
--
Diane

Hi,

If you only have these three possibillites you can simplify the formula to

=IF(A1="Circle",PI()*((G9+H9/12)/2)^2,((C9+D9/12)*(E9+F9/12))/IF(A1="Triangle",2,1))

The area of a triangle is 1/2 the area of the square.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Diane" wrote:

Can someone please help me with this function? I am trying to do a nested IF
function with three IF options (Circle, Triangle, Square).
I am trying to get Excel to automatically calculate an area (in sq ft) based
on its dimensions, broken up according to the shape of the room.

Rather than using multiple columns to do this, though, I want to consolidate
it into an easy-to-read form for the user, such that the "Shape" column is a
drop-down, validated to include Circle, Triangle, & Square. I want the "Area"
column to calculate the area of the space based on the shape selected. The
values for the formula dimensions will be captured in Length (FT & IN), Width
(FT & IN), and Radius (FT & IN).

This is the function that I've created, but it is giving me a general error.

=IF(A1="Circle€�,=(PI()*((G9+H9/12)/2)^2))),IF(A1="Triangle",=(((C9+D9/12)*(E9+F9/12))/2),IF(A1="Square",=((C9+D9/12)*(E9+F9/12))))

Any help regarding how to fix my formula would be greatly appreciated.

Thank you!
--
Diane