if condition help

[bhandari]

<bdo dir="ltr">Values need to check in H Column and I column

<bdo dir="ltr">if the cell "I5" is blank =</bdo><bdo dir="ltr">(D5*H5)-0.05%

if cell have "H5" value=(</bdo>D5*I5)-0.05%

Looking for help wiith this formula

=if(not(isblank(H5,I5),((D5*H5)-0.05%),</bdo><bdo dir="ltr">((D5*I5)-0.05%))</bdo>

 

[jtakw]

Hi,

Is this what you mean?

Book1
	B	C	D	E	F	G	H	I
5	1.9995		1				3	2
Sheet13

Cell Formulas
Range	Formula
B5	=IF(I5="",D5*H5-0.05%,IF(H5<>"",D5*I5-0.05%,""))

 

[bhandari]

2nd formula not working =IF(I5="",D5*H5-0.05%,IF(H5<>"",D5*I5-0.05%,""))

 

[bhandari]

<bdo dir="ltr">=IF(I5="",D5+J5,IF(H5<>"",,D5-J5,"")),i have modified to <bdo dir="ltr">=IF(I5="",D5+J5,IF(H5="",D5-J5,""))-->its working

<bdo dir="ltr">its working tnx</bdo>
</bdo></bdo>

 

[jtakw]

You're welcome, glad you got it working.