if formula help

[plost33]

i have the following formula:

=IF(B7>0,COUNTIF('Transaction Log'!$I$3:$I$10000,B7)>0,"")

The formula works fine except when i have a value in B7 of: =right(A7,7)


I have the right formula in alot of cells and the result fo that formula is "" because there is nothing in the respective "A" column.

anyone have any idea why my formula above does not work when the right formula is used?

 

[VoG]

Possibly

=IF(B7+0>0,COUNTIF('Transaction Log'!$I$3:$I$10000,B7+0)>0,"")

 

[plost33]

that gives me #VALUE! error

 

[VoG]

Try

=IF(B7="","",IF(B7+0>0,COUNTIF('Transaction Log'!$I$3:$I$10000,B7+0)>0,""))

 

[Whilock123]

I have the following formula but it has an error:

=if($D2= "General"(F2+G2)*37), if($D2 ="Oil"(F2+G2)*38), IF($D2 ="Soya/Fat"(F2+G2)*38), if($D2= "Molasses"(F2+G2)*37)

Could anyone help me?

Thanks in advance!