Sorry, relative newbie here.
I have a drop-down with two options in a cell in one tab - yes or no (Cell B7 - Tab is titled 'Details').
If the drop down selection is yes, i would like £5 adding to the formula already in another cell in another tab (Cell B12 - Tab is titled 'Workings'). Currently, that cell has this formula: =B10*F3
If the dropdown option selection is 'no', I don't want any amount adding to the value.
I'm guessing it's something along these lines: =IF(Details!B7='Yes',5,0)+(B10*F3) This doesn't work however!
Any help, much appreciated!
Bookmarks