Forum Discussion
How to have a cell A equal cell B IFERROR in cell C OR cell D, but empty if cell C isn't an error?
In E11:
=IF(ISERROR(I8), E8, "")
This will cause a problem with F12, so change the formula there to
=IF(E11="", "", E11/(D12^2)*-1)
In E11:
=IF(ISERROR(I8), E8, "")
This will cause a problem with F12, so change the formula there to
=IF(E11="", "", E11/(D12^2)*-1)
Sorry, one more thing (i hope.) I want to enter the largest whole number of a set of numbers that include decimals (specifically the largest whole number from P4:P54 entered into D16) and also possibly fix the repeating zeros in P4:P54 but still calculate the square root of the factors in O (eg. only calculate the factors until the last number in O then leave the rest of P blank)
Thanks so much for all your help so far!
Also: I haven't found any way to do the opposite of IFERROR, eg. ifNOTerror. I would like to have a formula similar to the one @HansVogelaar mentioned in cell E15, but IFERROR should be reversed in some way. Is there any way to do this?
=IF(NOT(ISERROR(something)), value_if_no_error, value_if_error)
- Perfect! Thanks for also helping with the error in F12! You are awesome!
