Forum Discussion
IF -Isblank function to check two cells are blank
Hi I was putting a formula in column P =IF(ISBLANK(M3),K3*N3,M3*N3)+O3 which checks if there is any value is there in column M and takes the rest calculation if M is blank... and if there is no va...
If both K3 and M3 are blank we return empty string. Just in case
ISBLANK(M3)*ISBLANK(K3)is equivalent of
AND(ISBLANK(M3),ISBLANK(K3))since in calculations TRUE is converted to 1 and FALSE to zero.
In second part
(K3*ISBLANK(M3)+M3)if M3 is blank that will be
(K3*1+0) or simply K3if M3 is not blank that will be
(K3*0+M3) or simply M3Thank you for marking as accepted solution, but better to move Best response on answer itself.
pillaisg , you are welcome
