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

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
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