If Statement help using two dropdown options

[jmneal]

Hi All, I am working on a spreadsheet and need to create an if statement for column Q based on what a user selects in another column. See below for details: You will see in column M that I have two options: "compressed" and non-compressed". If the user selects "non-compressed", column Q should reflect what is in column O. If the user selects "compressed" then I need the cell in column Q to have the formula =O13/12*10. Any help would be greatly appreciated!

If the user selects "non-compressed" in column M, then column Q should simply shoe the rent in column O...

If the user selects "compressed in the dropdown in column M, then column Q will have the below calculation....

 

[Z51]

I'd think you could use:

=IF(M13="Compressed",O13/12*10,IF(M13="Non-Compressed",O13,""))

 

[jmneal]

I tried this formula and it appears to be working perfectly. Thank you for the help and prompt response!