Thread: If Forumla
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Hawksby Hawksby is offline
external usenet poster
 
Posts: 16
Default If Forumla

Because you have more than 1 arguement in the formula you need to have more
than 1 if statement. It should read as follows

=IF L57="A", 1.10, if("B", 1.40, if("C", 1.20,0)))

"huntress731" wrote:

I'm so sorry I need help!!!!
I'm trying to do an "IF" formula but I'm not very knowledgeable with that
formula.
This is what I'm needing for example:

IF L57="A", 1.10, "B", 1.40, "C", 1.20

I hope that makes sense! No matter what I do it won't work. I'll try to
explain better if I need to.