| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rate function with #Num! result
Col"A" B C D E F
Y1 Y2 Y3 Y4 Y1-Y4 Revenue (13) (4) - 1 #NUM! Dear All, I try to use function =Rate to Calculate % at cell F4 Cell F4 =IF(E4=0,0,RATE(3,,-1,((+E4-B4)/B4)+1)) The Result is #Num!. Appreciate anyone can help with modify formula on this? Many Thanks & Best Regards PA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Currency to Text | Excel Worksheet Functions | |||
| Amount or Numbers in Words | New Users to Excel | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
