| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic source data based on Today | Charts and Charting in Excel | |||
| Source Range Data changing based on drop-down menu | Charts and Charting in Excel | |||
| Change Pie Chart segment color based on value in source data | Charts and Charting in Excel | |||
| Using formulas to source a value based on 2 variables | Excel Worksheet Functions | |||
| formatting color based on source column | Excel Discussion (Misc queries) | |||
Linear Mode
