Formula help!

[Gail]

I haven't used Excel in a long time, so your help would be
appreciated. I'm trying to come up with a formula that takes the
following into consideration. Customers subscribe to a service that
have an hourly cost, but costs can be determined by the fraction of
the hour. This hourly cost is different for subscribers and non
subscribers. An example would be the following:
Column E represents whether or not they are a subscriber/Column F is
their connection time (1/2 hour = 0.50)/Column G is their calculated
price. How do I do the following:
If E3=Y(Yes) then F3=0.50*130.00 therefore G3=65
If E3=N (No) then F3=0.50*350.00 therefore G3=175.
Assumptions are that Y=130.00 and N=350.00

Thanks for any help that you can provide!

Gail

 

[Norman Harker]

Hi Gail!

F3 formula:
=IF(E3="Y",0.5*130,IF(E3="N",0.5*350,""))

But rather than 0.5, 130 and 350, you would be much better off putting
those values in separate cells and referring to those cells.

Note that I default to an empty string "" if E3 isn't Y or N. Also
note that this reference to Y or N is not case sensitive.

 

[Gail]

Thanks Norman. I will give this a try today and hopefully it will be successful.

Regards,

Gail

 

[Gail]

Hi again, Norman. I tried it and it works beautifully! Thanks again
for your help on this!!!

Regards,

Gail