Forum Discussion
Sammy700
Mar 21, 2024Copper Contributor
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...
john006
Mar 21, 2024Copper Contributor
the correct formula may be =IFS (AND(D22-D18>3000000, D22-D18>5000000)