how can i linkup to different formulas

May 2, 2011 at 03:42:46
Specs: Windows 7
i need to make two sheet for attendance of staff, wherein i need to put a formula in dashboard sheet as discribed below....
if attendance sheet shows "xyz (cityname)" then dashboard sheet need to show "present"
if attendance sheet shows "absent" then dashboard sheet need to show "A"
if attendance sheet shows "leave" then dashboard sheet need to show "L"
if attendance sheet shows "week off" then dashboard sheet need to show "wo"

See More: how can i linkup to different formulas

Report •


#1
May 2, 2011 at 09:57:10
re: "if attendance sheet shows "xyz (cityname)" "

I assume that you mean "if a cell in attendance sheet shows xyz (cityname)..."

I also assume that "xyz (cityname) changes, but that "absent", "leave" and "week off" are constants.

How about this:

=IF('Attendance Sheet'!A1="absent", "A", IF('Attendance Sheet'!A1 = "leave", "L", IF('Attendance Sheet'!A1 = "week off", "wo", "present")))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question