RFI-Log- HICON GE ODT 14-09 V4.xlsxRFI-Log- HICON GE ODT 14-09 V4.xlsx
I have this form and I need to add one more value to select from 4 in my due day
=IF(B15="CRITICAL",C15+0.25,IF(B15="EXPEDITE",C15+0.5,C15+1))
thank in advance
RFI-Log- HICON GE ODT 14-09 V4.xlsxRFI-Log- HICON GE ODT 14-09 V4.xlsx
I have this form and I need to add one more value to select from 4 in my due day
=IF(B15="CRITICAL",C15+0.25,IF(B15="EXPEDITE",C15+0.5,C15+1))
thank in advance
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Maybe a different dropdown menu?
Select the cells you want the dropdown menu in
and do the following solution.jpg
(; might be , because of a different language in excel??)
solution.jpg right picture now i hope
Dont know why picture doesnt work...
Data --> Data validation --> List --> At variables (seperate with ; or if that doesnt work ,)
Use Data Validation as suggested above or the linked cell of the drop downs are in K15, k16... Change your formula referencing to Column 'k' instead of 'b'
Regards,
lokicl
Thank for your reply, but what I looking for is the capability went I put the priority request and add the date received have in due date the responte time + 3hrs, immediate +6, priority +12 and routine +24 whit the form I put only work until priority I need to add routine that I don no who
thank
Thank for your reply, but what I looking for is the capability went I put the priority request and add the date received have in due date the responte time + 3hrs, immediate +6, priority +12 and routine +24 whit the form I put only work until priority I need to add routine that I don no who
thank
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks