if statement question

[dyoung785]

IF(B$7<=DATEVALUE("12-31-15"),"4.91%","5.1%")

i have a variable(located in cell D12) that makes the false result in this if statement 5.0 instead of 5.1...
how do i write this in ...

thanks in advance

[AlKey]

This is because you have " " around you percentages
Try it like this

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[dyoung785]

let me make myself more clear the if statement as written works fine...

but I want to add a variable (located in d12) that would make the false result 5.0 instead of 5.1

[AlKey]

The mentioning of D12 as variable has no meaning without a further explanation.

[dyoung785]

it is just text in D12 that if certain text string is there the 5.1 needs to change to 5.0

let me say it another way: =IF(B$7<=DATEVALUE("12-31-15"),4.91%,5.1%) EXCEPT when D12="South & Western" then IF(B$7<=DATEVALUE("12-31-15"),4.91%,5.0%)

[Phuocam]

Try this ...

=IF(B$7<=DATE(2015,12,31),4.91%,IF(D12="South & Western",5%,5.1%))

[dyoung785]

Perfect, THANK YOU phuocam

[Phuocam]

You're welcome!