Forum Discussion
Solved
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...
I hv 5 cell in excel A,B,C,D & E
IF C,D,E BLANK THEN B-A
IF D&E BLANK C-A
IF E&C BLANK D-A
IF C&D BLANK E-A
I am trying to write formula since Sundays but fail kindly help me to write this formula in excel
IF C,D,E BLANK THEN B-A
IF D&E BLANK C-A
IF E&C BLANK D-A
IF C&D BLANK E-A
I am trying to write formula since Sundays but fail kindly help me to write this formula in excel
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")
