Brilliant! thank you!

"Luke M" wrote:

(Note that 30% = 0.3)
Something like the following:

=IF(A2=0.3, 200, "Does not meet criteria")
and format cell as currency/accounting to get the dollar symbol to appear
correctly.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ccKennedy" wrote:

hi,
i need a formula to input $200 if the cell in another workbook is greater
than or equal to 30%.
any ideas?