Formula needed thanx

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

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
 
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
 
Back
Top