Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help with excel IF function
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |