B
Bruce6735
Please review the following IF(AND) function [XXX] = ACTUAL RESULT
Row 20 F G H I J
[20.35] [10.00] =F21+G21 [30.35] =IF(G21<=20,G21,0) [10.00] =IF9AND(I21<20,H21>20)=TRUE,20-G21,0) [10.00]
I have a problem if the values of H is >20.00. the IF formula returns a null or "0" value in J. What I'd like for it to do in that case is return whatever the value of F happens to be. Hope this is not too confusing.
Thanks
Row 20 F G H I J
[20.35] [10.00] =F21+G21 [30.35] =IF(G21<=20,G21,0) [10.00] =IF9AND(I21<20,H21>20)=TRUE,20-G21,0) [10.00]
I have a problem if the values of H is >20.00. the IF formula returns a null or "0" value in J. What I'd like for it to do in that case is return whatever the value of F happens to be. Hope this is not too confusing.
Thanks