Help with "IF" statement

[Israelidf6]

I have 3 columns as shown: Order Amount, Outstanding, Status
<table style="border-collapse: collapse; width: 261px; height: 185px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 92pt;" width="122"> <col style="width: 62pt;" width="83"> <col style="width: 62pt;" width="82"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 92pt;" width="122" height="20">Order Amount</td> <td class="xl63" style="width: 62pt;" width="83">Outstanding</td> <td class="xl64" style="width: 62pt;" width="82">STATUS</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">400</td> <td align="right">400</td> <td class="xl65">Open</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">500</td> <td>
</td> <td class="xl65">Closed</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">365</td> <td align="right">365</td> <td class="xl65">Open</td> </tr> <tr style="height: 17.25pt;" height="23"> <td style="height: 17.25pt;" align="right" height="23">248</td> <td>
</td> <td class="xl65">Closed</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">259</td> <td>
</td> <td class="xl65">Closed</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">665</td> <td align="right">665</td> <td class="xl65">Open</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="right" height="20">225</td> <td align="right">225</td> <td class="xl65">Open</td> </tr> </tbody></table>
I need to write an "IF" statement in the Outstanding column stating that IF the STATUS column is "open" then the value in the cell will be exactly the amount from the previous column Order Amount. IF the STATUS says Closed then the value in the Outstanding column will be zero.

Can somebody tell me how to set this up? I dont know the syntax- i tried to write IF(M37="Open", K37,0) where column M=Status K= Order Amount

 

[lenze]

Hi and welcome to the board!!!
I don't see why you formula does not work!

=IF(M37="Open",K37,0)

is the correct syntax. Perhaps your cells contain blank spaces. In a blank cell, enter
=LEN(M37). Does it return 4?

lenze

 

[Israelidf6]

HA! Amazing what the difference between capital O and lowercase o can make. Thank you very much for the swift response anyway!