Formula based on source = 30%
 

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

Formula based on source = 30%
 

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

Formula based on source = 30%
 

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?

Formula based on source = 30%
 

"Luke M" wrote in message
...
(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 -----

"Luke M" wrote in message
...
(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?