Back to basics

[pickwa]

Hi guys, im a complete novice when it comes to excel however i have been asked by my employer to produce a spead sheet to manage data about fines.

I currently have one tab holding Consumer data that i want to use as my main input screen.

I am trying to make the data appear on the next tab if it is nessecary to send them a fine.

this is the formula i have written but i am abviously not quite getting it rite.

=IF('Patient input'!B2=yes,("0"),('Patient input'!A2))


Basically i have a list of Names on sheet one with a yes or no box next to it.
On tab two i want a list of fines to be sent so if there is a yes in that box then do nothing, if there is a no in the box add the name of the consumer to the list of fines to be sent on page 2.

Help anyone?

 

[Arcticwarrio]

=IF('Patient input'!B2="yes","",'Patient input'!A2)

 

[pickwa]

Thanks for getting back to me so quickly! unfortunately that formula just says '#name' when i enter it. maybe i need to go back to the drawing board.............really appreciate your attempt tho!

 

[pickwa]

scratch that it works! ...................thanks im determined that this spread sheet isnt going to beat me so your help has been greatly apprecaited!

 

[Arcticwarrio]

No Worries,

good to hear your sticking with it