Dec 27 2019 03:59 AM
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 value in M & K it returns 0.
If both M and K columns are blank I wish to get the value in P as blank... I don't want 0 to appear
Is there any possible way ….. Please guide...
Regards & thanks in advance.
Dec 27 2019 04:38 AM
Dec 27 2019 04:45 AM - edited Dec 27 2019 04:47 AM
SolutionDec 27 2019 04:58 AM
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 K3
if M3 is not blank that will be
(K3*0+M3) or simply M3
Thank you for marking as accepted solution, but better to move Best response on answer itself.
Dec 27 2019 05:37 AM
Dec 27 2019 05:59 AM
@pillaisg , you are welcome
Nov 09 2022 09:02 AM
Nov 09 2022 01:30 PM
In a cell in row 2, for example in F2:
=IFS(AND(C2="",D2="",E2=""),B2-A2,AND(D2="",E2=""),C2-A2,AND(C2="",E2=""),D2-A2,AND(C2="",D2=""),E2-A2,TRUE,"None of these")
Nov 19 2022 01:06 AM
Dec 27 2019 04:45 AM - edited Dec 27 2019 04:47 AM
Solution