Hi I need help

Im trying to set up an invoice checking spreadsheet, I nee a formula that
looks at a yes/no drop down in another cell, and then either copies a second
cell to the location or leaves it blank for example:

If A1 is selected as YES then make D1 = B1

and if A1 is selected as NO make E1 = B1

Hope this makes sense, what I'm trying to do is get the Invoice Balance to
show in a paid column in green and an unpaid column in red depending on
whether it is shown as Paid - Yes/No in the paid column.

Dave7881 wrote:
Hi I need help

Im trying to set up an invoice checking spreadsheet, I nee a formula that
looks at a yes/no drop down in another cell, and then either copies a second
cell to the location or leaves it blank for example:

If A1 is selected as YES then make D1 = B1

and if A1 is selected as NO make E1 = B1

Hope this makes sense, what I'm trying to do is get the Invoice Balance to
show in a paid column in green and an unpaid column in red depending on
whether it is shown as Paid - Yes/No in the paid column.

Dave,

In B1, write =IF(A1="YES",D1,IF(A1="NO",E1,""))

Beege

A different interpretation from Beege's

=IF(A1="YES",B1,"") in D1

=IF(A1="NO",B1,"") in E1


Gord Dibben MS Excel MVP


On Sat, 23 Feb 2008 06:18:00 -0800, Dave7881
wrote:

Hi I need help

Im trying to set up an invoice checking spreadsheet, I nee a formula that
looks at a yes/no drop down in another cell, and then either copies a second
cell to the location or leaves it blank for example:

If A1 is selected as YES then make D1 = B1

and if A1 is selected as NO make E1 = B1

Hope this makes sense, what I'm trying to do is get the Invoice Balance to
show in a paid column in green and an unpaid column in red depending on
whether it is shown as Paid - Yes/No in the paid column.