Formula based on source >= 30%

[ccKennedy]

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

 

[Luke M]

(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.

 

[ccKennedy]

Brilliant! thank you!

(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!*

 

[JoeU2004]

(Note that 30% = 0.3)
Something like the following:
=IF(A2>=0.3, 200, "Does not meet criteria")

And note that you can write A2>=30%, if you prefer.


----- original message -----