| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
value response
Hi Kaputa,
=IF(D30,LOG(C3/F3),""&TEXT(LOG(C3/10),"0.0")) Ed Ferrero Microsoft Excel MVP http://www.edferrero.com =IF(D30,LOG(C3/F3),""&LOG(C3/10)) gives me the two options that I want. Thanks to all who responded. Now, the first part is rounded to 1 decimal place, ie 0.0, because I chose so in custom mode. When the second part is true, however, I loose the custom formatting and get several decimal places added. How do I prevent this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula so that response is value | Excel Discussion (Misc queries) | |||
| How to write a formula so that response is value? | Excel Discussion (Misc queries) | |||
| polar response | Excel Discussion (Misc queries) | |||
| =(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
| Help Excel97 gives incorrect multiplication response | Excel Worksheet Functions | |||
Threaded Mode
