Mulitplication within an "IF" statement.

[Keith]

I have the following statement in cell C29...

=IF(RENOVATION!D17="Actual Measured SF",RENOVATION!B17,IF(RENOVATION!
D17="Open office plan light conf. rooms",".5",IF(RENOVATION!D17="Open
office with medium conf.",".75",IF(RENOVATION!D17="Perimeter hard
walled offices with open office core",1,0))))

For the last 3 "IF" statements...if the value is true then the
statement returns the values .5, .75, & 1 respectively. How could I
get the statement to multiply the .5, .75, & 1 values, respectively,
to cell C5 and return the value to cell C29? Can all this even be done
in the same cell using only one statement?

Thanks,
Keith

 

[Bob Phillips]

=IF(RENOVATION!D17="Actual Measured SF",RENOVATION!B17,
IF(RENOVATION!D17="Open office plan light conf. rooms",.5*C5,
IF(RENOVATION!D17="Open office with medium conf.",.75*C5,
IF(RENOVATION!D17="Perimeter hard walled offices with open
office core",C5,0))))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Keith]

 =IF(RENOVATION!D17="Actual Measured SF",RENOVATION!B17,
        IF(RENOVATION!D17="Open office plan light conf. rooms",.5*C5,
             IF(RENOVATION!D17="Open office with medium conf.",.75*C5,
                  IF(RENOVATION!D17="Perimeter hard walled offices with open
office core",C5,0))))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)









- Show quoted text -

Thanks for the feedback but I've tried that. Instead of actually multi
the numbers .5, .75, and 1, respectively, to cell C5...it just shows,
in cell C29, ".5*C5". Even if i put "=.5*C5" is still doesen't multi
them together.

 

[Bob Phillips]

I removed the quotes, it looks as if you have put them back in.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

=IF(RENOVATION!D17="Actual Measured SF",RENOVATION!B17,
IF(RENOVATION!D17="Open office plan light conf. rooms",.5*C5,
IF(RENOVATION!D17="Open office with medium conf.",.75*C5,
IF(RENOVATION!D17="Perimeter hard walled offices with open
office core",C5,0))))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)









- Show quoted text -

Thanks for the feedback but I've tried that. Instead of actually multi
the numbers .5, .75, and 1, respectively, to cell C5...it just shows,
in cell C29, ".5*C5". Even if i put "=.5*C5" is still doesen't multi
them together.