Formula not working

1996mustang

I have the follow formula. (See Below)

=IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2),IF($Status4<>"Close","Open"

If $Status4 = "Close" the formula returns a value. However, if $Status4 is not equal to "Close" I want the formula to return "Open". I get the following response #UNPARAEABLE The formula does work if I only use the following: =IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2) I either get a value or the cell is blank

Any suggestions?

Best Regards,

ds

L_123

=IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2, "Open")

Don't forget that if statements return if true AND if false, not a true and next.

L_123

=IF($Status4 = "Close", [ME BUD]4 * $[ME BUD]$2, "Open")

Don't forget that if statements return if true AND if false, not a true and next.

1996mustang

Thanks