This works:
=IF(A3<>"", 1,0 "")*$A$2
But this does not:
=IF(A3<>"", 1,0 "")*$A$2+IF(B3<>"", 1,0 "")*$B$2
The A3 turns into a color but the B3 does not. And when I press enter it says "There's a problem with this formula."
This works:
=IF(A3<>"", 1,0 "")*$A$2
But this does not:
=IF(A3<>"", 1,0 "")*$A$2+IF(B3<>"", 1,0 "")*$B$2
The A3 turns into a color but the B3 does not. And when I press enter it says "There's a problem with this formula."
Never mind
Last edited by reagr; 11-18-2022 at 07:16 AM.
pls try
=IF(A3<>"", 1,)*$A$2+IF(B3<>"",1,)*$B$2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks