Formula needed thanx

[Bob Vance]

--
What would I put in C1 if I wanted it to do this formula, A1*B1 but if there
is nothing in B1 it to show "No Charge"


Thanks in advance for your help....Bob Vance

 

[Don Guillett]

=if(b1="","No charge",a1*b1)

 

[Gord Dibben]

Bob

=IF(B1="","No Charge",A1*B1)

Gord Dibben XL2002

 

[dellfeng]

IF(B1=0,"No Charge",B1*A1)
if b1 contain no data , it will give the text no charge

----- Bob Vance wrote: ----



-
What would I put in C1 if I wanted it to do this formula, A1*B1 but if ther
is nothing in B1 it to show "No Charge


Thanks in advance for your help....Bob Vanc