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?
My issue is that I want to have cell E11 equal to cell E8 if cell I8 is an error, but have cell E11 be empty if cell I8 ISN'T an error. I have tried using various combinations of IFERROR and IF funct...
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!
