Forum Discussion
My formula is broken, not sure house to fix
Here is my formula =IFS(D22-D18>D18,{" "},D22-D18<D18,{"0"},D22-D18=D17,{"5000000"}) It is broken at the first part, I need it to come to a number that is between $3M and $5M, how do I get a number...
The only way to get "5000000" is if D18=D17 and D22=2*D17.
I doubt this is what you intend.
Other observations might be that treating scalar values as arrays {"5000000"}. Also, does the result need to be text?