Forum Discussion

KyneStaley1's avatar
KyneStaley1
Copper Contributor
Feb 22, 2023
Solved

When using IF formula how to return blank cell if error

Hi all,   Thanks for the help in advance. I have 2 issues which I'm having trouble with.   1. I'm currently trying to create an excel document which will subtract one cell from another however wh...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 22, 2023

    KyneStaley1 

    =IFERROR(IF(A12=6,E11-B12,""),"")

    This is the formula in sheet 1 which returns an empty cell in case of an error in my worksheet.

    =IF(ISERROR(IF('Kyne Loadfile Test 1'!A12=6,'Kyne Loadfile Test 1'!E11-'Kyne Loadfile Test 1'!B12,"")),'Kyne Loadfile Test 1'!E11,'Kyne Loadfile Test 1'!H11)

    This formula returns the value from cell E11 of sheet 1 if there is an error in the calculation E11-B12.

     

    Kyne Loadfile Test 1:

    Kyne Loadfile Test 2:

    .

     

KyneStaley1's avatar
KyneStaley1
Copper Contributor
Feb 23, 2023

OliverScheurich 

 

Firstly, thankyou for the response. This has solved the first issue however it hasn't resolved the second one. This has displayed all the original levels which were subject to error previously however it is not showing any of the previous levels which did not need any subtraction from them. Would it be possible to incorporate this into the formula as every time we were to use this excel document, the layout of which levels would need subtraction would be different. 

 

I have shown the formula used on both sheet 2 and sheet 1. Thankyou in advance.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 23, 2023

KyneStaley1 

You are welcome. I'm not sure what the expected results are. I've set up an Excel file with parts of your data. Can you share the expected results in cells E11, E12 and so on?

 

Sheet "Kyne Loadfile Test 2":

Resources