| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2.5-0.89¢-#VALUE!-2.5 - =IF((F3/H3)0,TEXT(F3/H3,"$0.00") No work
cells at a
2.5 = f3 / 0.89 = H3.. #value! should be: 0.36 =IF((F3/H3)0.99,TEXT(F3/H3,"$0.00"),TEXT(F3/H3,"0.00¢")) On another line with same formula: this works 8.3 $1.39 0.17¢ The only thing I can tell is that the second column is not less then $1.00 Please help me with this... thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Threaded Mode
