Jul 04 2019 06:22 PM
I have one cell (lets say it is cell Z20) in which I need several things evaluated and different things done based upon the answer. This is based upon dollar amounts in columns N and L. Both columns COULD have 0 in them, but BOTH columns will never have an amount over 0 (one column will always be 0)
Amount in cell Z15 is a subtotal of column Z.
If N20 is not 0 then multiply N20 by 15% (result in Z20) ---- I had =IF(n20<>0,N20*15%, " ")
If L20 is not 0, then amount in cell Z15 minus L20 (result in Z20) --- I had =IF(L20<>0,Z15-L20, " ")
If the result if false in both tests do nothing (leave blank) or put a zero in it.
My full statment was this: =IF(N20<>0,(N20*15%),IF(L20<>0,(Z15-L20)," "))
Can someone help me with this?
Jul 05 2019 12:10 AM
Jul 05 2019 08:14 AM
Jul 05 2019 08:22 AM