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 Trading], [Total Income Trading])))
 
The error message says, too many arguments were passed to the ISblank Function...
 
Thank you.
  • 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

2 Replies

  • 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

  • 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])