Set Cell Value from IF condition

[zit1343]

Hi
I am trying to set Cell B18 to something depending on if condition,

so in cell B16 I have this formula
=IF(B15>3,B18=11,B18=9)

it doesn't work plz help me,
I know I can type this formula in cell B18
=IF(B15>3,11,9)
but it doesn't do what I want it to,
I have script that send's email it B18 is greater than 10
it works but it only send email if I enter 11 manually in B18 , doesn't work if I type use if condition

Thanks

[jeffreybrown]

If B15 is greater than 3, how do you decide if B18 should be 11 or 9?

[zit1343]

if B15 is greater than 3, than get value of B18 = 11
if B15 is less than 3 than set value of B18 = 9

[Fotis1991]

Do you mean?

=IF(B15>3,11,IF(B15<3,9))

[zit1343]

Yes & No
I will put this formula in B16 =IF(B15>3,11,IF(B15<3,9))

I want B16 to change value in B18

[jeffreybrown]

I don't understand why another formula in B18 won't suffice?

Can you elaborate some more?