Oct 10 2024 11:06 AM
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 functions, but cant come up with a solution. I know basic excel functions but cant figure out some of the more complex ones and when/how to use them. I am trying to make a calculator that outputs all possible answers and stages of simplification of a simple ax^2+bx+c equation, so I am also trying not to mess up my other formulas in the process. Any suggestions? Here is my sheet for reference. Any tips on any of the other parts of the sheep would be great too.
Oct 10 2024 11:19 AM
Oct 10 2024 11:45 AM
=IF(ISERROR(I8),E8,"")
Oct 10 2024 11:45 AM
SolutionIn E11:
=IF(ISERROR(I8), E8, "")
This will cause a problem with F12, so change the formula there to
=IF(E11="", "", E11/(D12^2)*-1)
Oct 10 2024 03:24 PM
Oct 10 2024 03:30 PM
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?
Oct 11 2024 02:56 AM
=IF(NOT(ISERROR(something)), value_if_no_error, value_if_error)
Oct 11 2024 07:26 AM
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!
Oct 11 2024 11:48 AM
Oct 10 2024 11:45 AM
SolutionIn E11:
=IF(ISERROR(I8), E8, "")
This will cause a problem with F12, so change the formula there to
=IF(E11="", "", E11/(D12^2)*-1)