[Gadgetman]

Hi Guys, can you help me again??

What formula would I need to write in cell (G:4), which will add .5 to cell (G:4), if Yes is entered in (E4).

Cell (E:4) shows Yes.
Cell (F4) shows the cost
Cell (G:4) shows the cost of Cell (F:4) + .5 if Cell (E4) = Yes

Example:
E4________F4______G4
Yes/No____Cost_____Extra
Yes_______£2.00____£2.50

 

[RandyG]

=IF(E4="yes",F4+0.5,IF(E4="Yes",F4+0.5,""))

this looks and applies the +.5 whether it is spelled Yes or yes.

i wasn't sure what you wanted if it said anything else, or was blank, so just left the "" in there to display a blank cell if yes or Yes wasn't found.

 

[Gadgetman]

Thanks RandyG

 

[maxflia10]

=IF(E4="Yes",F4+.5,F4)

should do. It's not case sensitive and will take care of Yes or yes.

 

[Gadgetman]

Thanks, this forum comes up trumps one again!!