Forum Discussion

YWang100324's avatar
YWang100324
New Member
3 years ago
Solved

IF Blank

Hi,   Could you please review below formula as I couldn't get it to work...   % of Return = IF(ISBLANK( DIVIDE([Total Profit Trading], [Total Income Trading]), BLANK()), (DIVIDE([Total Profit T...
  • ppm1's avatar
    ppm1
    3 years ago

    You needed a 2nd ) at the end of your first DIVIDE, but you can just use this expression to get same result I believe.

     

    DIVIDE([Total Profit Trading], [Total Income Trading])

     

    Pat

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi YWang100324 

with your logic, try like:

% of Return = 
IF(
    ISBLANK(DIVIDE([Total Profit Trading], [Total Income Trading])), 
    BLANK(),
    DIVIDE([Total Profit Trading], [Total Income Trading])
)
 
or why not try directly:
% of Return=
DIVIDE([Total Profit Trading], [Total Income Trading])