Multiple IF commands

[Vijay2508]

Hello Freinds,
I'm working on a data were in B columns I'm having "Recharge" Or "Transfer".
I'm using IF formula to calculate the Transfer commission.
If " Recharge" Is there, then the commission should be "0".
Can anyone help to get this formula.

 

[tyija1995]

Hey,

You want something along the lines of this:

=IF(B1="Recharge",0,"Your transfer formula here")

 

[Vijay2508]

Thank you buddy, it's working...

 

[tyija1995]

Glad I could help!